- 2 2 Use The Reduction Technique You Learned In Chapter 12 To Map The Following Er Diagram To Relational Schemas Newspa 1 (64.75 KiB) Viewed 32 times
2.2) use the reduction technique you learned in chapter 12 to map the following ER diagram to relational schemas: Newspa
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
2.2) use the reduction technique you learned in chapter 12 to map the following ER diagram to relational schemas: Newspa
2.2) use the reduction technique you learned in chapter 12 to map the following ER diagram to relational schemas: Newspaper newspaperName (PK) Property For Rent Advertises phone 0.. 1.. propertyNo (PK) address address street street city city postcode postcode dateAdvert cost Newspaper (newspaperName, phone, street, city, postcode, proprtyNo) PropertyForRent (propertyNo, street, city, postcode, newspaperName) 2.3) Fill in the table below to indicate the foreign keys in the schemas you obtained in the previous step and the primary key that corresponds to each foreign key: Foreign key Primary key Property No in newspaper PropertyNo in PropertyForRent newspaperName in Property ForRent Newspaper Name in Newspaper