blog




  • Essay / Entity Relationship Diagram - 613

    Entity Relationship DiagramWhen developing a relational database, understanding the logical flow of information and proper planning will improve the likelihood that the database will perform as planned and produces the desired results. Determining the appropriate structure of a relational database for a video rental store requires consideration of the information stored, the video rental process, and the video information held in inventory. Customer, Videos and Video Types are the entity classes that will be discussed and Customer Order is the intersection relationship needed to explain the complete process, as shown in the entity relationship diagram below. CustomerMaintaining detailed customer information is an essential relationship function of a video rental store. database. The primary key of the Customer entity class can be a field named Customer ID Number which is a unique number automatically generated when a new customer is entered. The video store could also choose to use a unique number identifying the customer such as driver's license number, telephone number....