Ask a question from expert

Ask now

COIT20247- Database Design

8 Pages1760 Words306 Views
   

Central Queensland University

   

Database Design and Development (COIT20247)

   

Added on  2020-03-04

About This Document

The below-given report discusses the database management system and database design. This assessment is also going to discuss how to develop a conceptual data model based on the given case study.

COIT20247- Database Design

   

Central Queensland University

   

Database Design and Development (COIT20247)

   Added on 2020-03-04

BookmarkShareRelated Documents
STUDENT NAMESTUDENT IDCOURSE IDCOURSE NAME
COIT20247- Database Design_1
Contents1.ERD..........................................................................................................................................................................32.Business rules..........................................................................................................................................................43.Assumptions............................................................................................................................................................44.Entities and attribute definitions.............................................................................................................................4Complaint....................................................................................................................................................................4Staff.............................................................................................................................................................................4Client...........................................................................................................................................................................5Booking.......................................................................................................................................................................5Service.........................................................................................................................................................................5Car_for_service...........................................................................................................................................................5Parts............................................................................................................................................................................5Sales............................................................................................................................................................................5Sales_car.....................................................................................................................................................................6Normalization up to 3NF.................................................................................................................................................6References......................................................................................................................................................................8
COIT20247- Database Design_2
1.ERDEntity relationship diagram modelled using Chens notation.Figure 1: Entity religion diagram
COIT20247- Database Design_3

End of preview

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

Related Documents
COIT20247-Database Design and Development
|7
|737
|293

COIT20247, Database Design and Development
|12
|1703
|53

Database Design and Implementation for a Vehicle Service Business - Desklib
|21
|5533
|240