logo

ITECH 1006 - Database Management Systems

14 Pages4017 Words282 Views
   

Added on  2019-10-30

ITECH 1006 - Database Management Systems

   Added on 2019-10-30

ShareRelated Documents
Assignment 2ITECH 1006 – Database Management SystemsStudent ID –Date -Module Tutor -
ITECH 1006 - Database Management Systems_1
Report on Database ImplementationTask 1Relational Schema1.GENREAttributeDatetypeKeygenreIDINTPKgenreNameTEXT(50)DescriptionTEXT(250)2.SUPPLIERAttributeDatetypeKeysupplierIDINTPKsupplierNameTEXT(50)ContactTEXT(50)PhoneTEXT(15)EmailTEXT(50)AddressTEXT(50)SuburbTEXT(50)PostcodeTEXT(5)CountryTEXT(50)CommentsTEXT(250)3.ACTORAttributeDatetypeKeyactorIDINTPKfirstNameTEXT(50)lastNameTEXT(50)PlaceOfBirthTEXT(100)DateOfBirthDATEDateOfDeathDATE4.INVENTORYAttributeDatetypeKeyinventoryIDINTPKtitleTEXT(250)unitPriceDECIMAL(5,2)markupDECIMAL(5,2)discountDECIMAL(5,2)qtyInStockINTgenreIDINTFKsupplierIDINTFK
ITECH 1006 - Database Management Systems_2
5.MANUFACTURERAttributeDatetypeKeymanufacturerIDINTPKmanufacturerNameTEXT(50)PhoneTEXT(15)EmailTEXT(50)AddressTEXT(50)SuburbTEXT(50)PostcodeTEXT(5)CountryTEXT(50)6.DIRECTORAttributeDatetypeKeydirectorIDINTPKfirstNameTEXT(50)lastNameTEXT(50)PlaceOfBirthTEXT(100)DateOfBirthDATEDateOfDeathDATE7.COLLECTIONAttributeDatetypeKeycollectionIDINTPKcollectionNameTEXT(50)DescriptionTEXT(250)dateReleasedDATE8.COLLECTIBLEAttributeDatetypeKeyinventoryIDINTPK/FKmadeYearINTmanufacturerIDINTFK9.COLLECTION_MEMBERAttributeDatetypeKeycollectionIDINTPK/FKinventoryIDINTPK/FK10.MOVIEAttributeDatetypeKeyinventoryIDINTPK/FKreleaseYearINTclassificationTEXT(5)
ITECH 1006 - Database Management Systems_3
starRatingINTdirectorIDINTFK11.CASTAttributeDatetypeKeyactorIDINTPK/FKinventIDINTPK/FKroleTEXT(50)12.CUSTOMERAttributeDatetypeKeycustomerIDINTPKfirstNameTEXT(50)lastNameTEXT(50)PhoneTEXT(15)EmailTEXT(50)AddressTEXT(100)PostcodeINTloyaltyDiscountDECIMAL(5,2)13.RECEIPTAttributeDatetypeKeyreceiptIDINTPKcustomerIDINTFKreceiptDateDATE14.PURCHASEAttributeDatetypeKeyreceiptIDINTPKinventoryIDINTFKquantityINTamountPaidDECIMAL(5,2)(Paul Litwin n.d)( Tutorialspoint 2016)
ITECH 1006 - Database Management Systems_4

End of preview

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

Related Documents
ITECH1006 Database Management Systems
|15
|4119
|238

ITECH 1006 Assignment on Database Management Systems
|15
|4127
|27

ITECH 1006 Database Management Systems | Assignment
|15
|4148
|242

ICT701 Relational Database Systems
|9
|851
|121