logo

ITECH 1006 Database Management Systems | Assignment

15 Pages4148 Words242 Views
   

Database Management Systems (ITECH 1006)

   

Added on  2020-03-23

ITECH 1006 Database Management Systems | Assignment

   

Database Management Systems (ITECH 1006)

   Added on 2020-03-23

ShareRelated Documents
Assignment 2ITECH 1006 – Database Management SystemsStudent ID –30329735Student Name - Date –Tutor Name -
ITECH 1006 Database Management Systems | Assignment_1
Report Task 1Relational Schema1.GENREAttributeDatetypeKeyFiielddgenreIDINTEGERPRIMARY KEYFiielddgenreNameCHAR(50)FiielddDescriptionCHAR(250)2.SUPPLIERAttributeDatetypeKeyFiielddsupplierIDINTEGERPRIMARY KEYFiielddsupplierNameCHAR(50)FiielddContactCHAR(50)FiielddPhoneCHAR(15)FiielddEmailCHAR(50)FiielddAddressCHAR(50)FiielddSuburbCHAR(50)FiielddPostcodeCHAR(5)FiielddCountryCHAR(50)FiielddCommentsCHAR(250)3.ACTORAttributeDatetypeKeyFiielddactorIDINTEGERPRIMARY KEYFiielddfirstNameCHAR(50)FiielddlastNameCHAR(50)FiielddPlaceOfBirthCHAR(100)FiielddDateOfBirthDATEFiielddDateOfDeathDATE4.INVENTORYAttributeDatetypeKeyFiielddinventoryIDINTEGERPRIMARY KEYFiielddtitleCHAR(250)FiielddunitPriceDECIMAL(5,2)FiielddmarkupDECIMAL(5,2)FiieldddiscountDECIMAL(5,2)FiielddqtyInStockINTEGERFiielddgenreIDINTEGERFOREIGN KEYFiielddsupplierIDINTEGERFOREIGN KEY
ITECH 1006 Database Management Systems | Assignment_2
5.MANUFACTURERAttributeDatetypeKeyFiielddmanufacturerIDINTEGERPRIMARY KEYFiielddmanufacturerNameCHAR(50)FiielddPhoneCHAR(15)FiielddEmailCHAR(50)FiielddAddressCHAR(50)FiielddSuburbCHAR(50)FiielddPostcodeCHAR(5)FiielddCountryCHAR(50)6.DIRECTORAttributeDatetypeKeyFiieldddirectorIDINTEGERPRIMARY KEYFiielddfirstNameCHAR(50)FiielddlastNameCHAR(50)FiielddPlaceOfBirthCHAR(100)FiielddDateOfBirthDATEFiielddDateOfDeathDATE7.COLLECTIONAttributeDatetypeKeyFiielddcollectionIDINTEGERPRIMARY KEYFiielddcollectionNameCHAR(50)FiielddDescriptionCHAR(250)FiieldddateReleasedDATE8.COLLECTIBLEAttributeDatetypeKeyFiielddinventoryIDINTEGERPRIMARYKEY/FOREIGN KEYFiielddmadeYearINTEGERFiielddmanufacturerIDINTEGERFOREIGN KEY9.COLLECTION_MEMBERAttributeDatetypeKeyFiielddcollectionIDINTEGERPRIMARYKEY/FOREIGN KEYFiielddinventoryIDINTEGERPRIMARYKEY/FOREIGN KEY
ITECH 1006 Database Management Systems | Assignment_3
10.MOVIEAttributeDatetypeKeyFiielddinventoryIDINTEGERPRIMARYKEY/FOREIGN KEYFiielddreleaseYearINTEGERFiielddclassificationCHAR(5)FiielddstarRatingINTEGERFiieldddirectorIDINTEGERFOREIGN KEY11.CASTAttributeDatetypeKeyFiielddactorIDINTEGERPRIMARYKEY/FOREIGN KEYFiielddinventIDINTEGERPRIMARYKEY/FOREIGN KEYFiielddroleCHAR(50)12.CUSTOMERAttributeDatetypeKeyFiielddcustomerIDINTEGERPRIMARY KEYFiielddfirstNameCHAR(50)FiielddlastNameCHAR(50)FiielddPhoneCHAR(15)FiielddEmailCHAR(50)FiielddAddressCHAR(100)FiielddPostcodeINTEGERFiielddloyaltyDiscountDECIMAL(5,2)13.RECEIPTAttributeDatetypeKeyFiielddreceiptIDINTEGERPRIMARY KEYFiielddcustomerIDINTEGERFOREIGN KEYFiielddreceiptDateDATE14.PURCHASEAttributeDatetypeKeyFiielddreceiptIDINTEGERPRIMARY KEYFiielddinventoryIDINTEGERFOREIGN KEYFiielddquantityINTEGERFiielddamountPaidDECIMAL(5,2)(Lucid Software Inc. 2015)
ITECH 1006 Database Management Systems | Assignment_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
|14
|4017
|282

Assignment on Database PDF
|14
|2236
|34

H16W 35 Relational Database Management Systems
|16
|1641
|138

Case Study Project on Normalisation
|5
|749
|393