logo

Database Design with MySQL | Assignment

9 Pages739 Words235 Views
   

Added on  2020-04-01

Database Design with MySQL | Assignment

   Added on 2020-04-01

ShareRelated Documents
Running head: DATABASE DESIGNDatabase DesignName of the StudentName of the University
Database Design with MySQL | Assignment_1
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 Design with MySQL | Assignment_2
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
Database Design with MySQL | Assignment_3

End of preview

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

Related Documents
Business Intelligence and Database
|21
|1939
|178

Entity Relationship Diagram (ERD) represents the real-world objects as Entities and relationship between them.
|15
|1780
|11

Hospital Assesment And Review Management
|16
|1869
|19

Revised ERD and Schema for a Restaurant Database
|4
|1628
|451

TRA Race Entry System Author: Name + Number.
|7
|471
|85

Accounting Information System (AIS) Assignment
|16
|1125
|185