Database Design with MySQL | Assignment

Added on - 01 Apr 2020

  • 9

    Pages

  • 739

    Words

  • 125

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 9 pages
Running head:DATABASE DESIGNDatabase DesignName of the StudentName of the University
DATABASE DESIGN1Table of Contents1. Entity Relationship Diagram:......................................................................................................22. Relational Tables up to Third Normal Form:..............................................................................22.1 Dependency Diagram:...............................................................................................................53. Database Creation:.......................................................................................................................54. Form Creation for Divisions:.......................................................................................................65. Data Input into Tables:................................................................................................................66. Query Creation:...........................................................................................................................77. Report:.........................................................................................................................................8Bibliography:...................................................................................................................................9
DATABASE DESIGN21. Entity Relationship Diagram:Assembly_DivisionOrderPartOrder_PartSupplierSupplier_PartDiv_IDPKDiv_NameContact_Person_NameContact_Person_PhoneOrder_IDPKDate_of_OrderPart_noPKPart_DescriptionPart_NameOrder_Part_IDPKOrder_IDFKPart_noFKQuantityIn_StockSupplier_IDPKSupplier_NameSupplier_NumberSupplier_EmailSupplier_Postal_AddressSupplier_Part_IDPKSupplier_IDFKPart_noFKFigure 1: Entity Relationship Diagram of Next Generation Auto(Source: Created by Author)2. Relational Tables up to Third Normal Form:AssemblyDivisionEntityData TypeKeyDivIDVarchar2PrimaryDivNameVarchar2NoneContactPersonNameVarchar2NoneContactPersonPhoneINTNone
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document