logo

ICT211 Database Design Assignment

6 Pages689 Words49 Views
   

Database Design (ICT211)

   

Added on  2020-04-01

ICT211 Database Design Assignment

   

Database Design (ICT211)

   Added on 2020-04-01

ShareRelated Documents
ICT211 Database DesignTask 2Student ID –Student Name- Date -Module Tutor -
ICT211 Database Design Assignment_1
ReportPart A: Database DesignER Diagram(Cinergix Pty Ltd. 2011)
ICT211 Database Design Assignment_2
Relational Schema1.BreedAttributeData TypeKeyFIIELDBreedTypeNCHAR(100)PKFIIELDBreedNCHAR(100)PK2.CauseOfAfflictionAttributeData TypeKeyFIIELDCauseOfAfflictionNCHAR(500)PK3.DiagnosisAetiologyAttributeData TypeKeyFIIELDDiagnosisAetiologyNCHAR(500)4.CarerGroupsAttributeData TypeKeyFIIELDPermitNumberNCHAR(20)PKFIIELDCarerGroupNameNCHAR(500)FIIELDExpiryDateDATE5.CarerGroupSpecializationAttributeData TypeKeyFIIELDPermitNumberNCHAR(20)PK/FKFIIELDSpecializationNCHAR(200)PK6.CarersAttributeData TypeKeyFIIELDCarerIDNCHAR(20)PKFIIELDPermitNumberNCHAR(20)FKFIIELDPermitOptionsNCHAR(200)FIIELDFirstNameNCHAR(50)FIIELDLastNameNCHAR(50)FIIELDPhoneNCHAR(20)FIIELDMobileNCHAR(20)FIIELDEmailNCHAR(50)FIIELDAddressNCHAR(100)FIIELDCityNCHAR(50)FIIELDStateNCHAR(50)FIIELDCountryNCHAR(50)FIIELDPostCodeNCHAR(4)
ICT211 Database Design Assignment_3

End of preview

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

Related Documents
ICT211 - Relational Database Design
|6
|701
|111

ICT211 Database Design Assignment
|6
|685
|111

ITECH 1006 - Database Management Systems FUA
|7
|741
|205

ER Diagram, Relational Data Logical Model, Data Dictionary
|6
|563
|75

ICT701 Relational Database Systems
|9
|851
|121

Database Design ITC211
|6
|522
|36