Entity Relationship Diagram When developing a relational database, understanding the logical flow of information and proper planning will improve the likelihood that the database will function as intended and produce the desired results . When determining the correct structure of a relational database for a video rental store you need to consider what information is stored, the video rental process, and information about videos maintained in inventory. Customer, Video 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 illustrated in the entity relationship diagram below. Customer Maintaining detailed customer information is a key function of a video rental store's relationship database. The primary key of the Customer entity class might be a field called Customer ID Number which is a unique number automatically generated when a new customer is entered. The video store may also choose to use a unique number that identifies the customer such as driver's license number, telephone number...
tags