Ask a question from expert

Ask now

Next Generation Auto Business Rules

6 Pages639 Words231 Views
   

Added on  2020-04-07

Next Generation Auto Business Rules

   Added on 2020-04-07

BookmarkShareRelated Documents
Next Generation- AutoBusiness Rules: The Next Generation Auto is the vehicle manufacturing company. The company manufactures vehicles like car, truck, bike etc. The company consists of different divisions. Each division builtparticular type of vehicle. When a vehicle is to be built by a division they order for the vehicle parts that are needed to the purchasing officer of the company. The purchasing officer checks for the available stock in the company and then orders the supplier for the parts required by the division. Some of the business rules followed to develop the database are given below:a)Each division is uniquely identified by its unique id. The division information such as thename, contact person of the division and the phone number of the division are maintainedby the databaseb)The Company maintains the stock list of the parts. Each part is uniquely identified with the part_id. Each part is given a name and the number of parts available must be maintained in the database.c)The company is connected with many suppliers. Each supplier is identified by the unique supplier_id. The supplier information such as their name, contact information like phone number, Email address and postal address are maintained by the database.d)It is possible that a supplier can supply one or more parts to the next generation company and a part can be supplied by one or more supplier to the next generation auto company.e)Each orders placed by the division is maintained with the unique order_id. The database maintains information about the date the order was placed together with the id of the division that places the order.f)Each order placed by the division may contain one or more parts. The database maintains the information about the part description provided by the division in the order placementtogether with the required quantityEntity Relationship Diagram:The Entity relationship diagram (ERD) for the Next Generation Auto Company is shown below. The ERD shows the primary and foreign keys involved in each of the entity.
Next Generation Auto Business Rules_1
Division_IDDivisionNameContactPerson PhoneNumberOrder_IDOrderDateDivision_IDPart_IDName QtyInStockOrder_ID Part_ID PartDescription QtyOrdered Relational table Design:Division (Division_ID Text,DivisionName Text,ContactPerson Text, PhoneNumber Text);Primary Key – Division_IDOrders(Order_ID number,OrderDate date, Division_ID Text);Primary Key – Order_IDParts(Part_ID number, Name text, QtyInStock number);Primary Key – Part_IDPartsOrdered(Order_ID number, Part_ID number, PartDescription Text, QtyOrdered number);Primary Key – Order_ID, Part_IDForeign Key – Part_ID references Parts (Part_ID)-Order_ID references Orders (Order_ID)Supplier(Supplier_lD number,Name Text, PhoneNo Text, Email Text, PostalAddress Text );Primary Key – Supplier_IDPartsSupplier(Part_ID number,Supplier_ID number);Primary Key – Part_ID, Supplier_IDForeign Key – Part_ID references Parts (Part_ID)-Supplier_ID references Supplier (Supplier_ID)Dependency Diagram:Division:OrdersPartsPartsOrdered:
Next Generation Auto Business Rules_2
Supplier_lD Name PhoneNo Email PostalAddressPart_ID Supplier_ID Supplier:PartsSupplier:Division Form:Queries:Query:SELECT * FROM Parts;Output:
Next Generation Auto Business Rules_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Sales And Marketing Management Database System Assignment
|28
|1151
|183

Database Design in MS Access and MYSQL - Assignment
|22
|711
|222

Advanced Management Console
|35
|7601
|31

A Model Description: Jo Bloggs Auto Traders
|4
|815
|451