Information System Assignment | Logical Data Model

Added on - 19 Sep 2019

  • 10

    pages

  • 1133

    words

  • 64

    views

  • 0

    downloads

Showing pages 1 to 3 of 10 pages
ASSIGNMENT: Create a Class DiagramSubject:Information SystemTopic:logical data modelTHE PURPOSE OF THIS ASSIGNMENT IS TOCREATE A LOGICAL DATA MODEL AND APPLYRULES OF NORMALIZATION TO THE MODELPage1
Assignment: Create a logical data Model for the dealership keeps information about each carmanufacturer 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 carriesfrom each manufacturer. They keep such information as list price, the price the dealership paid toobtain the model, and the model name and series (e.g., Honda Civic LX). They also keepinformation 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 thebuyers in the future, contact information is also kept (e.g., address, phone number).According to the assignmentJim Smithkeep track of information of manufacturer and carinformation according to the class diagram on cars model can be deals by different dealer andalso manufacturer can deals with many dealers. According to the requirement the cardinality ofthe relations may change.According to the assignment we have generate the database query to show the relation betweenmanufacturer, dealer, seller and buyer.MANUFACTURERCREATE 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.Page2
Class DiagramManufacturerMID ( Primary Key)AddressPhoneFaxEmailContact PersonCarsVIN (Primary Key)MakeModelSeriesYeaeList PriceCustomersCust ID (Primary Key)First NameLast NameAddressPhoneEmailSalesSales Order ( PrimaryKey)Cust IDDATEVINPriceDealerDealerShipIDDealer NameAuthorisedContact NoPage3
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document