Access
Q1: Our Friend Los Gatos realizing that his wallcovering business had a few wrinkles in it, decide to pursue a law degree at night. After graduating, he has teamed up with Lyla El Pajaro to form Peck and Paw, Attorneys at Law. Los and Lyla have hired you to design a database system based upon the following set of business rules. It is in your best interest to perform a though analysis, to avoid needless litigation. Please create an ERD based upon the following set of rules:
An ATTORNEY is retained by one or more CLIENTS for each CASE. Attributes for ATTORNEY are Attorney ID, Name Address, City, State, Zip Code, Specialty (may be more than one), and Bar (may be more than one).
A CLIENT may have more than one ATTORNEY for each CASE. Attributes for CLIENT are Client ID, Name, Address, State, Zip Code, Telephone, and Date of Birth.
A CLIENT may have more than one CASE.
Attributes for CASE are Case ID, Case Description, and Case Type.
An ATTORNEY may have more than one CASE.
Each CASE is assigned to one and only one COURT.
Attributes of COURT are Court ID, Court Name, City, State, and Zip Code.
Each COURT has one or more JUDGES assigned to it.
Attributes for JUDGE are Judge ID, Name, and Year In Practice.
Please state any assumptions that you have made. Also, draw a data model for this situation.
Q2: develop an EER model for the following situation.
An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:
Room is identified by Building ID and Room No and also has a Capacity. A room can be either a Lab or a Classroom. If it is a classroom, it has an additional attribute called Board Type.
Media is identified by MType ID and has attributes of Media Type and Type Description. Note: her we are taking type of media (such as a VCR, projector, etc.), not the
An ATTORNEY is retained by one or more CLIENTS for each CASE. Attributes for ATTORNEY are Attorney ID, Name Address, City, State, Zip Code, Specialty (may be more than one), and Bar (may be more than one).
A CLIENT may have more than one ATTORNEY for each CASE. Attributes for CLIENT are Client ID, Name, Address, State, Zip Code, Telephone, and Date of Birth.
A CLIENT may have more than one CASE.
Attributes for CASE are Case ID, Case Description, and Case Type.
An ATTORNEY may have more than one CASE.
Each CASE is assigned to one and only one COURT.
Attributes of COURT are Court ID, Court Name, City, State, and Zip Code.
Each COURT has one or more JUDGES assigned to it.
Attributes for JUDGE are Judge ID, Name, and Year In Practice.
Please state any assumptions that you have made. Also, draw a data model for this situation.
Q2: develop an EER model for the following situation.
An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:
Room is identified by Building ID and Room No and also has a Capacity. A room can be either a Lab or a Classroom. If it is a classroom, it has an additional attribute called Board Type.
Media is identified by MType ID and has attributes of Media Type and Type Description. Note: her we are taking type of media (such as a VCR, projector, etc.), not the