Database Management System (DMS) Assignment

   

Added on  2020-05-16

5 Pages531 Words198 Views
Running head: DATABASE MANAGEMENT SYSTEMDatabase Management SystemName of the StudentName of the University
Database Management System (DMS) Assignment_1
DATABASE MANAGEMENT SYSTEM1Relational Schema:Table: CUSTOMERAttributeData TypePrimary KeyForeigncustomerIDintYesfirstNamevarchar (40)lastNamevarchar (40)phoneintemailvarchar (40)addressvarchar (40)suburbvarchar (40)postcodeintloyaltyDiscountdoubleTable: ORDERAttributeData TypePrimary KeyForeignorderIDintYescustomerIDintCUSTOMER (customerID)dateOrderedDATEdateFulfilledDATEpostageAmountdecimal(10,2)discountApplieddoubleTable: INVENTORY
Database Management System (DMS) Assignment_2

End of preview

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

Related Documents
ITECH 1006 : The Database Management System Report
|21
|3550
|123

Fundamentals On Database Question and Answer 2022
|6
|616
|26

Relational Database Design - Assignment
|8
|517
|271

Data Warehousing Assignment 1
|9
|552
|236