Entity Relationship Diagram Essay

734 words - 3 pages

Entity Relationship Diagram
When developing a relational database understanding the logical flow of information and proper planning will improve the probability of the database functioning the way it is intended and producing the desired results. In determining the proper structure of a relational database for a video rental store one must consider what information is stored, the process for renting videos and information on the videos maintained in inventory. Customer, Videos and Video Types are the entity classes that will be discussed and Customer Order is the intersection relation needed to explain the complete process as seen on the Entity Relationship Diagram below.

...view middle of the document...

Each customer may zero or many Customer Orders, but each Customer Order must have one and only one customer. The Customer Order must have at least one video, but may have many videos. A specific video must only be rented to one customer at a time and may not be rented out to any customers.
Videos and Video Types
The video entity class is a table containing the video library. The video store may own multiple copies of each video to rent to multiple customers, but each video would be assigned a unique number used as the primary key. Each unique video can only be rented to one customer at a time, but the customer may rent multiple videos with each order. The video entity class would contain information related to the video such as title, director, year released and main actors. The video rental store may also want to track the type of video so they can easily locate it in their store. A video type entity class would contain a list of categories or sections within the video store. The primary key would be a unique number automatically generated when a new category is added to the table. If categories are later combined or names are changed,...

Find Another Essay On Entity Relationship Diagram

Huffman Trucking Company: Database Management System - Request for Proposal: Description of Team Red Consulting, Inc

1005 words - 4 pages maintenance database system will include the requirements as follows:TRCI will use the following Entity-Relationship Diagram (ERD) to develop the Unified Modeling Language Use Case and Class Diagrams.Unified Modeling Language (UML) Use Case Diagram.Unified Modeling Language helps the user to visualize the system requirements, and describes designs by depicting the details of implementation. Unified Modeling Language remains at the top of the

Object And Process Modeling, And Stragies For System Analysis And Problem Solving

1094 words - 4 pages addition the application of encapsulation involves keeping the external representation of an entities properties and methods independent of its actual implemented use. Encapsulation therefore, allows an entity to be leverage by other parts of an application without the fear of changes in the implementation use causing a snowball effect. Process Modeling Logical Process modeling is a technique for organizing and documenting the structure and

Riordan Manufacturing Business-To-Business Database System

5480 words - 22 pages goals.Riordan Business-to-Business Database NormalizationOne of the steps in modeling the new business-to-business web portal for Riordan Manufacturing is to take the information gathered in the analysis and planning phase and develop a data model, which will be used as a roadmap to the design and development of the physical database.The first step in this process is developing an Entity Relationship Diagram (ERD). This ERD shows and identified the

project plan

1524 words - 7 pages project has multiple employees as team members and also defines role for each team member for the project such as Project Manager, Team Lead, Developer and Functional… Entity-Relationship (E-R) The Entity-Relationship diagram above describes the relationship between tables. The diagram also states the primary key and foreign key of each table schema. For example, Employee Table has a primary key of EmployeeID. This primary key is a

Fundamentals of Database Design

2210 words - 9 pages –Relationship diagram * Review Local Conceptual Data Model with User Logical design: Build and Validate Local Logical Data Model: * Map Local Conceptual Data Model to Local Logical Data Model * Derive Relations from Local Logical Data Model * Validate Model using Normalization * Validate Model against User Transactions * Draw Entity-Relationship Diagram * Define Integrity Constraints Build and Validate Global Logical Data Model: * Build

database mgt

2471 words - 10 pages relationships in an ERD to be displayed by their binary type. The types of Crow's Foot Notation's and their respective Binary Types are displayed below:Figure 1. This diagram illustrates the binary types and thier respective Crow's Foot Notation (Interpreting Entity-Relationship Diagrams, n.d.).In order to create the ERD with the entities and attributes listed in Chart 1, their relationships must be established. For instance, the table "Vehicles

Huffman Trucking: Database Implementation

714 words - 3 pages scope of the project, Huffman's business goals and assumptions. We will then present our findings concerning the projects technical, operational, and economic feasibility. We will also include a diagram of the current business process and list the system requirements we propose.Statement of Scope.In exploring possibilities to help Huffman Trucking expand and develop Entity-Relationship Diagrams for Fleet Truck Maintenance and a Normalized Database

phase 1 individual project

2211 words - 9 pages Relationship Diagram (ERD)ER modeling is a data modeling technique used to produce a conceptual data model of an information system. Diagrams created using this ER-modeling technique are called Entity-Relationship Diagrams, or ER diagrams or ERDs. So you can say that Entity Relationship Diagrams illustrate the logical structure of databases.ER-DIAGRAM OF A COMPANYThe original notation for ER-Diagrams uses rectangles to represent entities, and diamonds to

Organization Structure and Management

1009 words - 5 pages profit and it concentrates on market segment as well as product offering. Strategic business unit typically have a distinct marketing plan, marketing campaign, competition analysis though they may appear as part of a bigger commercial entity. A strategic business unit maybe a branch or a business in itself or may be a unit of business in a bigger corporation. Companies may be made up of multiple strategic business units and each unit is in charge

Management of information system for libraries

1838 words - 7 pages maintains information about the recommendations made by users for new purchases by the library.ENTITY - RELATIONSHIP DIAGRAMThe entity relationship diagram is as shown below. Various attributes of the different entities of the system are shown in the section following.DESIGNData DesignIn data design the entity relationship diagram is converted into database. Various tables in the database are as follows.1. catalog:Field Type Length Null

Proposed a system

928 words - 4 pages all about what is in the system and how it really operates and helps in managing customer’s details. For the customers, they just have to simply open the system to check out what are the CDs that available to be borrowed and just have to key in their details if they want to borrow something from the store. Entity Relational Diagram BORROWER Borrower_ID Borrower_Name Borrower_Address Staff_ID Date_Requested Date_Loaned

Similar Essays

The Entity Relationship Diagram Essay

1244 words - 5 pages The Entity Relationship Diagram (ERD) depicts a conceptual data model that incorporates some of the important scientific information about the real world. It adopts a natural view that the real world consists of entities and relations (Chen, 1976). One objective of the ERD is to create a simple, easy to understand and conveniently presented data model consisting of entities, attributes, relationships and cardinalities. The model serves as tool

Entity Relationship Model Vs. Semantic Object Model

275 words - 2 pages An Entity Relationship Model, also known as an Entity Relationship Diagram, a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data; an object or concept about which data is stored. A relationship is how the data is shared between entities. The three types of relationships between entities

This Paper Talking About Database Management Systems

571 words - 2 pages data entities are given meaning through the flow of information in the system.Drafting initial Entity-Relationship diagram with entities and relationships: the relationships between various data entities are established and documented using an Entity-Relationship diagram.Refining the Entity-Relationship diagram: Entity-Relationship diagram is further refined by removing ambiguities and repetitionsAdd key attributes to the diagram: from the former

Developing A Payment Data Warehouse Essay

1162 words - 5 pages entities and their relationships to each other. An entity can be a piece of data, an object, or a concept about which data is stored. A relationship is how the data is shared between entities. There are three types of relationships between entities: 1. One-to-One - One example of an entity (A) is associated with one other example of another entity (B). 2. One-to-Many - One example of