Question: Question 1 (15 marks) The relational database below contains two related tables - Manager and Sub-ordinate: name 1688 Sub-ordinate table: Primary key = Sub-code, Foreign

Question 1 (15 marks) The relational database below contains two related tables - "Manager" and "Sub-ordinate": name 1688 "Sub-ordinate" table: Primary key = Sub-code, Foreign key = Man -code Sub-code Sub Sub-deptSub Sub-phone Sub -Man-code areacode renew Date 10010 zzz sales 123445677 2017-11-14 501 10011 XXX Jaccount 1606 |234567899 2017-11-16 501 10012 yyy IT 232 345678900 2017-11-13 502 10013 Jeee sales 234 454577777 2017-10-13 503 10014 lui sales 231 436436885 2017-10-23503 10015 sdg account 175 1676446322 2017-10-30 504 10016 ewt legal 789 232317879 2017-12-30 502 Manager" table: Primary key = Man -code, No Foreign key Man-code Man-Iname Man-fname Man -Initial Man-areacode Man-phone 501abcabcnbvcF 1615 123445678 502 werte hjjkgdf B 6 15 2 34567890 503 zxcvb pooliuu X 234 345678901 a. From the above data, what type of relationships: one-to-one, one-to- many, or many-to-many, do the above two tables have? Explain your answer. (5 marks) b. The above database contains an error in the data. Identify and describe this error. (5 marks) c. Why does "Manager table has no foreign key and why does "Sub- ordinate" table has foreign key? Describe the use of primary and foreign keys in databases. Illustrate with examples in your answers

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!

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 2 The relational database below contains two related tables - Supplier and Product: Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod...

The relational database below contains two related tables - Supplier and Product Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype...

The relational database below contains two related tables - Supplier and Product: Product table: Primary key = Prod-code, Foreign key = Supp-code Prod-code Prod -name Prod -desript Prod -stocktype...

Question B3 (5 marks): Below is a relational database (4 related tables) for a retail flower shop that sells different types of orchid flowers. Note that the raw data in each table below is...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

database management system COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI AHMI DR. MOHD...

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...

1.Write one SQL statement to set up table MoSpo HallOfFame according to the following Relational Schema: MoSpo HallOfFame(hoFdriverId, hoFYear, hoFSeries, hoFImage, hoFWins, hoFBestRaceName,...

Question 4 (25 marks) Case: Retail Database Design You have engaged a software vendor to design a database to capture both retail outlets essential data. The key areas of your concerns are sales...

Station WRCH in Richmond, Virginia, is interviewing candidates for the job of news anchor on its 6:00 P.M. Eyewitness News show. There are three final candidates for the jobJune Pawlie, Kellie...

Compute ratios for Kohl's using the balance sheet below and match to the correct amount. (Dollars in Millions) Assets Current assets: Cash and cash equivalents Merchandise inventories Other Total...

12. Some stellar constellations are spiral-shaped objects. Th erefore, no stellar constellations are spiral-shaped objects. Use the modern square of opposition to determine whether the following...

How to solve this question? Richard's preferences over chocolate, c, and money, m, can be represented by the utility function: u(c, m) = 6c + m + 6 (c r c ) + (m r m ) where r c is his chocolate...