Logical Data Model : Assignment

ASSIGNMENT: Create a Class Diagram
Subject: Information System
Topic: logical data model
THE PURPOSE OF THIS ASSIGNMENT IS TO
CREATE A LOGICAL DATA MODEL AND APPLY
RULES OF NORMALIZATION TO THE MODEL
Page
1

Assignment: Create a logical data Model for the dealership keeps information about each car
manufacturer with whom it deals so that employees can get in touch with manufacturers easily.
The dealership also keeps information about the models of cars that staff the dealership carries
from each manufacturer. They keep such information as list price, the price the dealership paid to
obtain the model, and the model name and series (e.g., Honda Civic LX). They also keep
information about all sales that they have made. (For instance, they will record the buyer’s name,
the car he or she bought, and the amount he or she paid for the car.) So that staff can contact the
buyers in the future, contact information is also kept (e.g., address, phone number).
According to the assignment Jim Smith keep track of information of manufacturer and car
information according to the class diagram on cars model can be deals by different dealer and
also manufacturer can deals with many dealers. According to the requirement the cardinality of
the relations may change.
According to the assignment we have generate the database query to show the relation between
manufacturer, dealer, seller and buyer.
MANUFACTURER
CREATE TABLE MANUFACTURER
(
M_ID NUMBER,
ADDRESS VARCHAR2 (30),
CONTACT_PERSON CHAR (20),
PHONE NUMBER,
FAX VARCHAR2 (50),
EMAIL VARCHAR2 (50),
, # Here Dealer ID and manufacturer ID are the primary key.
DEALER_ID NUMBER REFERENCES DEALER (DEALERSHIP_ID),
CONSTRAINT MANUFACTURER_PK PRIMARY KEY ( MANUFACTURER_ID )
);
===================================================================
Here I have design class diagram for all the available relation.
Page
2

Class Diagram
Manufacturer
MID ( Primary
Key)
Address
Phone
Fax
Email
Contact Person
Cars
VIN (Primary Key)
Make
Model
Series
Yeae
List Price
price paid
Customers
Cust ID (Primary
Key)
First Name
Last Name
Address
Phone
Email
Sales
Sales Order
( Primary Key)
Cust ID
DATE
VIN
Price
Dealer
DealerShipID
Dealer Name
Authorised
Contact No
Page
3