logo

Analysis & Database Development

   

Added on  2022-08-19

8 Pages256 Words20 Views
Database
Development
Analysis & Database Development_1
Introduction
The database has been designed for the AMC
organization.
The database has been designed on XAMPP
Seven entities have been identified here and the
associated attribute have also been identified.
Analysis & Database Development_2
ER Diagram
Products
Order
Stores ProductsOrdered
Patrons
Department
Employees
ProductNumberPK
ProductTitle
UnitPrice
OrderNumberPK
OrderDate
NumberOfProducts
StoreIDPK
Name
Address
IDPK
ProductNumberFK
OrderNumberFK
CustomerIDPK
LastName
FirstName
DeptIDPK
DeptName
EmployeeIDPK
LastName
FirstName
PhoneNumber
Address
QuantityOrdered
StoreIDFK
DeptIDFK
FaxNumber
CustomerIDFK
EmployeeIDFK
Analysis & Database Development_3

End of preview

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

Related Documents
Entity Relationship Diagram docx
|14
|2468
|15

Database Management System
|15
|2546
|89

Database Management System
|17
|1391
|112

Database Design and Development
|5
|955
|111

Database Management for Business
|33
|3886
|410

Development of HR Database for Torrens We Help Inc.
|12
|1165
|474