logo

ITECH1006 Database Management Systems

15 Pages4119 Words238 Views
   

Database Management Systems (ITECH 1006)

   

Added on  2020-05-08

ITECH1006 Database Management Systems

   

Database Management Systems (ITECH 1006)

   Added on 2020-05-08

ShareRelated Documents
Assignment 2ITECH 1006 – Database Management SystemsStudent ID –Student Name - Date –
ITECH1006 Database Management Systems_1
Report Task 1Relational Schema1.GENREAttributeDatetypeKeyFidgenreIDINTEGERPRIMARY KEYFidgenreNameTEXT(50)FidDescriptionTEXT(250)2.SUPPLIERAttributeDatetypeKeyFidsupplierIDINTEGERPRIMARY KEYFidsupplierNameTEXT(50)FidContactTEXT(50)FidPhoneTEXT(15)FidEmailTEXT(50)FidAddressTEXT(50)FidSuburbTEXT(50)FidPostcodeTEXT(5)FidCountryTEXT(50)FidCommentsTEXT(250)3.ACTORAttributeDatetypeKeyFidactorIDINTEGERPRIMARY KEYFidfirstNameTEXT(50)FidlastNameTEXT(50)FidPlaceOfBirthTEXT(100)FidDateOfBirthDATEFidDateOfDeathDATE4.INVENTORYAttributeDatetypeKeyFidinventoryIDINTEGERPRIMARY KEYFidtitleTEXT(250)FidunitPriceDECIMAL(5,2)FidmarkupDECIMAL(5,2)FiddiscountDECIMAL(5,2)FidqtyInStockINTEGERFidgenreIDINTEGERFOREIGN KEY
ITECH1006 Database Management Systems_2
FidsupplierIDINTEGERFOREIGN KEY5.MANUFACTURERAttributeDatetypeKeyFidmanufacturerIDINTEGERPRIMARY KEYFidmanufacturerNameTEXT(50)FidPhoneTEXT(15)FidEmailTEXT(50)FidAddressTEXT(50)FidSuburbTEXT(50)FidPostcodeTEXT(5)FidCountryTEXT(50)6.DIRECTORAttributeDatetypeKeyFiddirectorIDINTEGERPRIMARY KEYFidfirstNameTEXT(50)FidlastNameTEXT(50)FidPlaceOfBirthTEXT(100)FidDateOfBirthDATEFidDateOfDeathDATE7.COLLECTIONAttributeDatetypeKeyFidcollectionIDINTEGERPRIMARY KEYFidcollectionNameTEXT(50)FidDescriptionTEXT(250)FiddateReleasedDATE8.COLLECTIBLEAttributeDatetypeKeyFidinventoryIDINTEGERPRIMARYKEY/FOREIGN KEYFidmadeYearINTEGERFidmanufacturerIDINTEGERFOREIGN KEY9.COLLECTION_MEMBERAttributeDatetypeKeyFidcollectionIDINTEGERPRIMARYKEY/FOREIGN KEY
ITECH1006 Database Management Systems_3
FidinventoryIDINTEGERPRIMARYKEY/FOREIGN KEY10.MOVIEAttributeDatetypeKeyFidinventoryIDINTEGERPRIMARYKEY/FOREIGN KEYFidreleaseYearINTEGERFidclassificationTEXT(5)FidstarRatingINTEGERFiddirectorIDINTEGERFOREIGN KEY11.CASTAttributeDatetypeKeyFidactorIDINTEGERPRIMARYKEY/FOREIGN KEYFidinventIDINTEGERPRIMARYKEY/FOREIGN KEYFidroleTEXT(50)12.CUSTOMERAttributeDatetypeKeyFidcustomerIDINTEGERPRIMARY KEYFidfirstNameTEXT(50)FidlastNameTEXT(50)FidPhoneTEXT(15)FidEmailTEXT(50)FidAddressTEXT(100)FidPostcodeINTEGERFidloyaltyDiscountDECIMAL(5,2)13.RECEIPTAttributeDatetypeKeyFidreceiptIDINTEGERPRIMARY KEYFidcustomerIDINTEGERFOREIGN KEYFidreceiptDateDATE14.PURCHASEAttributeDatetypeKeyFidreceiptIDINTEGERPRIMARY KEYFidinventoryIDINTEGERFOREIGN KEY
ITECH1006 Database Management Systems_4

End of preview

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

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

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

ITECH 1006 - Database Management Systems
|14
|4017
|282

Assignment on Database PDF
|14
|2236
|34

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

Create database `My_BIS325`;.
|3
|535
|309