Answer Happy

1. Transform the EER model (Appendix A) to Relational tables, making sure you show all the

steps. The final set of tables should contain necessary information such as table names,

attribute names, primary keys (underlined) and foreign keys (in italics).

[60%]

2. a) Write create table statements to implement the tables in the ORACLE Relational DBMS.

When creating tables make sure you choose appropriate data types for the attributes,

specify any null/not null or other constraints whenever applicable, and specify the

primary and foreign keys.

b) Write at least one insert statement for each of your tables using realistic data. Make sure

you take into consideration all the necessary constraints.

[40%]

Submission note: You are required to submit two documents:

1. a PDF file with the answers for Task 1, where you clearly show all the relevant

transformation steps for the given EER model.

2. a text file (.txt) or an SQL file (.sql) for Task 2, where you have all the create table statements

and insert statements.
TASKS: 1. Transform the EER model (Appendix A) to Relational tables, making sure you show all the steps. The final set of tables should contain necessary information such as table names, attribute names, primary keys (underlined) and foreign keys (in italics). [60%] 2. a) Write create table statements to implement the tables in the ORACLE Relational DBMS. When creating tables make sure you choose appropriate data types for the attributes, specify any null/not null or other constraints whenever applicable, and specify the primary and foreign keys. b) Write at least one insert statement for each of your tables using realistic data. Make sure you take into consideration all the necessary constraints. [40%] Submission note: You are required to submit two documents: 1. a PDF file with the answers for Task 1, where you clearly show all the relevant transformation steps for the given EER model. 2. a text file (.txt) or an SQL file (.sql) for Task 2, where you have all the create table statements and insert statements.
ClientEmail Business Address ClientAddress PickUpDate ClientPhone Equipment EqName MaxRentDurationDays E Status Cliente Inspection Date Corporation Name ClientName DropDate Corporate N (ON) 1 (0, N) M(0, M) Q Electrical d Client Hires Equipment Individual JobID Mechanical 1 (0,N) QuoteAmount Property Owner Job Description Creates JobAddress QuoteStatus Creates N (1,1) Urgency level Business Postcode Casual NON) M (OM) Quotes BusinessName Contact Name Contact Number Job d N (1,1) N (1,1) ) N (1,1) 1 (0, N) ContactEmail Contract Assigned BusinessAddress StartDate Belongs to ANNumber EndDate N N (1,1) Has M (1,M) Business Postcode Industry 1 (0, 1) 1 (0, N) N (0, N) Industry N (ON) Fallinto 1 (0, N) SuburbName Industry Title d 1 (0,N) ) Has Has Suburb 1 (1,1) Has Seminario N (1.1) Invoice Union Review N (1, N) 1 (1, N) Freelancer Seminar Title Union Title CorpBusiness InvoiceNo Review SemDateTime UContact Name Union U Adja Amount ReviewDate SeminarVenue UContact No Elite Member Email M (1,M,L Review Rating ReviewText Attends Career UAddress Elite Member MO, M) N (5, N) Seminar