Using the EASYDRIVE SCHOOL OF MOTORING CASE STUDY DOCUMENT ATTACHED
1) Create a local conceptual data model(ER Diagram)pls. use words drawing tools.
2) Create a transaction pathways diagram to validate the local conceptual data model against the query transactions describe in the case study.
3) Create and validate a local logical data model from the local conceptual data model.
The response addresses the queries posted the 3 diagrams with references.
// As per the requirements of the paper, the first part presents the ER diagram by taking relevant guidance from the case study of Easy Drive School of Motoring//
The Easy Drive School of Motoring Case Study
1. ER Diagram (Connolly & Begg, 1999).
Please see the file.
//After giving the ER ...
Diagram attached in detail.
Simple Relationship Diagrams: ER diagrams
The problems below use the Customer, OrderTbl, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The OrderTbl contains the basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are CustNo for Customer, EmpNo for Employee, and OrdNo for OrderTbl.
The following is the TABLE definitions for the first three tables showing the PRIMARY KEY constraints.
TABLE Customer has the following attributes
CustNo is the PRIMARY KEY
TABLE Employee has the following attributes
EmpNo is the PRIMARY KEY
TABLE OrderTbl has the following attributes
OrdNo is the PRIMARY KEY
Step 1 - Drawing the first ER Diagram
Identify the foreign key columns in the table structures above and draw a relationship diagram depicting the relationships between the tables. In the Order Table (OrderTbl in the diagram), the CustNo column references the Customer table and the EmpNo column references the Employee table. For each relationship, identify the table on the "1" side of the relationship and the table on the "Many" side.
Step 2 - Should a NULL be allowed?
From examination of the sample data and your current understanding of businesses in which orders could be placed either in person, over the phone, or over the internet determine if it would be permissible for null values to be allowed for the foreign key Empno in the OrderTbl table? This column would reference back to the empno column in the employee table. Why or why not?
OrdNo OrdDate CustNo EmpNo
O1656777 02/11/2000 C8543321
O7959898 02/19/2000 C8543321 E8544399
Step 3 - Drawing the second ER Diagram
In a separate diagram, extend your relationship diagram from problem 1 by adding two tables (OrdLine and Product). Table definitions for the table structures and primary keys constraints are shown below. You will need to identify the FOREIGN KEY(s) to complete this problem. When finished you should have a total of 5 tables represented in your diagram for this problem.
TABLE Product has the following attributes
ProdNo is the PRIMARY KEY
TABLE OrdLine has the following attributes
The combination of OrdNo and Prodno is the PRIMARY KEY