| City| textbook| 20| State| textual matter| 20| Postcode| textbook| 4| Phone| text| 12| Entity name: Staff Attributes: Attributes| attribute| Size | Staff_ID| Int| 4| give| schoolbook| 20| Position| textual matter| 10| Salary| topic| 5| Entity name: DVD Attributes: Attributes| Type| Size | Catalogue_NO| Int| 8| DVD_NO| Int| 8| surname| textbook| 20| Category| Text| 20| Daily Rental| capital| 10| Cost| Money| 10| Status| Text| 10| Name_o f_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| meshing| 15| Entity name: Rental Attributes: Attributes| Type| Size | Rental_NO| Int| 8| Member rootage 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 fivesome entities which are Branch Address, Staff, DVD, Member and Rental (b) Identify the main akin(predicate)ds between the entities described in (a) and represent each kin as an ER diagram. (5 marks) (c) Determine the multiplicity constraints for each affinity described in (b). Represent the multiplicity for each relationship in the ER diagrams created in (b). (5 marks) (d) Identify attributes and associate them with entity or rel ationships. 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) manipulation your answers (a) to (e) attempt to represent the data requirements of the DVD rental attach to as a single ER...If you want to get a full essay, order it on our website: OrderEssay.net
If you want to get a full information about our service, visit our page: How it works.
No comments:
Post a Comment