Question: Question 2 Below is a database with 2 tables - Marina, Technician: Marina table: primary key = Marina Number, foreign key = Tech Number, Technician

Question 2 Below is a database with 2 tables -

Question 2 Below is a database with 2 tables - Marina, Technician: Marina table: primary key = Marina Number, foreign key = Tech Number, Technician table: primary key = Tech Number, no foreign key * Relationships Marina Technician Marina Number Tech Number Marina Name Last Name Address First Name City Address State Zip Code State Warranty Zip Code Non-warranty Hourly Rate Tech Number YTD Earnings City The above is a relational schema or entity relationship diagram for 2 tables: Marina and Technician. Explain why the above relational schema does NOT indicate the type of relationship (one-to-one, one-to-many, many-to-many) between these 2 tables, and describe potential problems that may occur

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel without...

Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

Section C (40 marks) Question (C1): Below is a database with 2 tables - Marina, Technician: Marina table: primary key = Marina Number, foreign key = Tech Number, Technician table: primary key = Tech...

Section C (40 marks) Question (C1): Below is a database with 2 tables - Marina, Technician: Marina table: primary key = Marina Number, foreign key = Tech Number, = Technician table primary key = Tech...

Question (C1): Below is a database with 2 tables - Marina , Technician : Marina table : primary key = Marina Number, foreign key = Tech Number, Technician table : primary key = Tech Number, no...

Below is a database with 2 tables - Marina, Technician: Marina table: primary key = Marina Number, foreign key = Tech Number, Technician table: primary key = Tech Number, no foreign key Relationships...

Question 1 (15 marks) The relational database below contains two related tables - "Manager" and "Sub-ordinate": Iname 501 Sub-ordinate table: Primary key = Sub -code, Foreign key = Man -code Sub-code...

Question (C3): (3 marks) Below is a database with 2 tables - Lecturer, Student: Student table: primary key = Stud_Num, foreign key = Lect_num Student_Num Stud_lastname Stud_firstname Year Lect_Num...

The question SQL Oracle Database : Print the total amount, the average dollar value of service visits (parts and labour costs) and the number of those visits for Acura, Mercedes and Jaguar car makes...

On June 30, 2017, Wisconsin, Inc., issued $358,600 in debt and 17,500 new shares of its $10 par value stock to Badger Company owners in exchange for all of the outstanding shares of that company....

On January 1, 2007 the Boonville Corporation is delinquent on a $300,000 note to the Great National Bank on which $66,000 of interest has accrued. On January 2, 2007 Boonville enters into a debt...

VIDEO PHONES, INCORPORATED Income StatementVIDEO PHONES, INCORPORATED Balance Sheets December 3 1 \ begin { tabular } { | l | l | l | } \ hline \ multicolumn { 3 } { | c | } { VIDEO PHONES,...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...