Database Design in MS Access and MYSQL PDF

Added on - 03 Jan 2021

  • 22

    pages

  • 711

    Words

  • 10

    Views

  • 0

    Downloads

Showing pages 1 to 6 of 22 pages
Database design in MS Access and MYSQL1
TABLE OF CONTENTSINTRODUCTION...............................................................................4PART 1.............................................................................................4PART 2............................................................................................11CONCLUSION..................................................................................152
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
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
2.Relational database tablesCustomer table5
Queries6
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document