logo

Database Design in MS Access and MYSQL - Assignment

22 Pages711 Words222 Views
   

Added on  2020-10-05

Database Design in MS Access and MYSQL - Assignment

   Added on 2020-10-05

ShareRelated Documents
Database design in MS Access and MYSQL1
Database Design in MS Access and MYSQL - Assignment_1
TABLE OF CONTENTSINTRODUCTION...............................................................................4PART 1.............................................................................................4PART 2............................................................................................11CONCLUSION..................................................................................152
Database Design in MS Access and MYSQL - Assignment_2
INTRODUCTIONDatabase is a collection of elements that manage, update, insert, retrieve the informationin form of tables and columns. This report will discuss about relational database and analyses theinformation and data. It also designs an effective and efficient database that help for managingthe entire database in a proper manner.PART 11.Entity relationship diagramFigure: 1Entity relationship diagram is a graphical representation which help for providing theinformation of particular organizations. Entity relationship diagram is creating aneffective relationship between entities and attributes. Fig: 1 show entities and theirspecific attributes.Entities: Primary key:Foreign key:For Example-Inventory:Primary key: inventory_id3
Database Design in MS Access and MYSQL - Assignment_3
Foreign Key: customer_idCustomer:Primary key: customer_idForeign Key: product_idSales order:Primary key: sale_idForeign Key: Supplier:Primary key: supplier_idForeign key: sales_id, inventory_idPurchased order:Primary key: purchased_idForeign key: customer_id, supplier_id4
Database Design in MS Access and MYSQL - Assignment_4
2.Relational database tablesCustomer table5
Database Design in MS Access and MYSQL - Assignment_5
Queries6
Database Design in MS Access and MYSQL - Assignment_6

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 and Development
|20
|2372
|2

Database Design and Implementation Assignment
|19
|811
|294

Database of Business Rules Entities and Attributes
|20
|2546
|433

Database Fundamentals: ER Diagram, BCNF, SQL Queries, Optimization, Security, Web Interface
|23
|2632
|88

(PDF) Database Management System
|24
|1258
|484