| City| textbook| 20| State| textual matter| 20| Postcode| textual matter| 4| Phone| text| 12| Entity name: Staff Attributes: Attributes| symbol| Size | Staff_ID| Int| 4| abduce| text edition| 20| Position| text edition| 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| property| 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| reckon| 15| Entity name: Rental Attributes: Attributes| Type| Size | Rental_NO| Int| 8| Member outgrowth 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 fiver entities which are Branch Address, Staff, DVD, Member and Rental (b) Identify the main raceds between the entities described in (a) and represent each kin as an ER diagram. (5 marks) (c) Determine the multiplicity constraints for each family described in (b). Represent the multiplicity for each race in the ER diagrams created i n (b). (5 marks) (d) Identify attribute! s 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) determination your answers (a) to (e) attempt to represent the data requirements of the DVD rental follow as a single ER...If you want to get a full essay, order it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment