(a) Identify the important entities of the DVD rental corporation. (5 marks) Entity scream: fork manoeuver Attributes: Attributes| causa| Size | Branch_No| Int| 4| Street| textbook| 50??| City| textbook| 20| State| textual matter| 20| Postcode| textual matter| 4| Phone| textbook| 12| Entity name: Staff Attributes: Attributes| typecast| Size | Staff_ID| Int| 4| see| textbook| 20| Position| school text| 10| Salary| topic| 5| Entity name: DVD Attributes: Attributes| Type| Size | Catalogue_NO| Int| 8| DVD_NO| Int| 8| surname| schoolbook| 20| Category| Text| 20| Daily Rental| funds| 10| Cost| Money| 10| Status| Text| 10| Name_of_the main actors| Text| 60| Director| Text| 20| Entity name: segment Attributes: Attributes| Type| Size | Member_NO| Int| 8| Local Branch| Int| 4| maiden Name| Text| 20| finishing Name| Text| 20| Address| Text| 50| insure| eon| 15| Entity name: Rental Attribute s: Attributes| Type| Size | Rental_NO| Int| 8| Member primary Name| Text| 20| Member Last Name| Text| 20| DVD_NO| Int| 8| DVD Title| Text| 20| Daily Rental| Money| 10| Date_Out| Date| 15| Date_Reture| Date| 15| There ar tailfin entities which are Branch Address, Staff, DVD, Member and Rental (b) Identify the main consanguineousds between the entities described in (a) and represent each kin as an ER diagram. (5 marks) (c) Determine the multiplicity constraints for each race described in (b). Represent the multiplicity for each kindred in the ER diagrams created in (b). (5 marks) (d) Identify attributes and associate them with entity or relationships. Represent each attribute in the ER diagrams created in (c). (5 marks) (e) Determine candidate and primary key attributes for each (strong) entity. (5 marks) (f) do your answers (a) to (e) attempt to represent the data requirements of the DVD rental political party as a single ER.. .If you want to get a full essay, order it o! n our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment