Ask a question from expert

Ask now

ICT211 - Relational Database Design

6 Pages701 Words111 Views
   

University of the Sunshine Coast Queensland Australia

   

Database Design (ICT 211)

   

Added on  2020-03-01

About This Document

In this document, we will discuss the database design of ER Diagram. Also, we cover the following assumptions: a one carer group may contain so many specializations, so many carers, the date and time of the DNA sample report should be saved in the database and all accession numbers should be saved along with medicines.

ICT211 - Relational Database Design

   

University of the Sunshine Coast Queensland Australia

   

Database Design (ICT 211)

   Added on 2020-03-01

BookmarkShareRelated Documents
Relational Database DesignICT211 Task 2Student ID –Student Name- Date -Module Tutor -
ICT211 - Relational Database Design_1
ReportPart A: Database DesignER Diagram(WebFinance 2017)(Techtarget 2017)
ICT211 - Relational Database Design_2
Relational Schema1.BreedAttributeData TypeKeyFIELDBreedTypeNVARCHAR(100)PKFIELDBreedNVARCHAR(100)PK2.CauseOfAfflictionAttributeData TypeKeyFIELDCauseOfAfflictionNVARCHAR(500)PK3.DiagnosisAetiologyAttributeData TypeKeyFIELDDiagnosisAetiologyNVARCHAR(500)4.CarerGroupsAttributeData TypeKeyFIELDPermitNumberNVARCHAR(20)PKFIELDCarerGroupNameNVARCHAR(500)FIELDExpiryDateDATE5.CarerGroupSpecializationAttributeData TypeKeyFIELDPermitNumberNVARCHAR(20)PK/FKFIELDSpecializationNVARCHAR(200)PK6.CarersAttributeData TypeKeyFIELDCarerIDNVARCHAR(20)PKFIELDPermitNumberNVARCHAR(20)FKFIELDPermitOptionsNVARCHAR(200)FIELDFirstNameNVARCHAR(50)FIELDLastNameNVARCHAR(50)FIELDPhoneNVARCHAR(20)FIELDMobileNVARCHAR(20)FIELDEmailNVARCHAR(50)FIELDAddressNVARCHAR(100)FIELDCityNVARCHAR(50)FIELDStateNVARCHAR(50)FIELDCountryNVARCHAR(50)FIELDPostCodeNVARCHAR(4)
ICT211 - Relational Database Design_3

End of preview

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

Related Documents
ICT211 Database Design Assignment
|6
|685
|111

ICT211 Database Design Assignment
|6
|689
|49

ICT701 Relational Database Systems
|9
|851
|121

ITECH1006 | Database Management System
|8
|701
|101

BIT358: Advanced Database Assignment
|10
|1155
|310

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