ASSIGNMENT 1
DATA MODELING,
MANAGEMENT AND
GOVERNANCE - CIS108-6
Database Development and Creation
Abstract
Exhibit a balanced and systematic understanding and knowledge of data modelling and management
theory and data governance practice (including querying languages).
Apply knowledge of data modelling and management concepts to design, develop and critically
evaluate an information system within a chosen field of interest.
, Contents
Table Of Figures...........................................................................................................................................2
Scenario.......................................................................................................................................................3
Question 1 – Use Case.................................................................................................................................3
Diagram:..................................................................................................................................................3
Description:.............................................................................................................................................4
Question 2 – Entity Relationship Diagram/Model.......................................................................................5
Diagram:..................................................................................................................................................5
Description:.............................................................................................................................................5
Question 3 – Tables.....................................................................................................................................7
SQL Query for creating tables:.................................................................................................................7
Description:.............................................................................................................................................8
DATA MODELING,
MANAGEMENT AND
GOVERNANCE - CIS108-6
Database Development and Creation
Abstract
Exhibit a balanced and systematic understanding and knowledge of data modelling and management
theory and data governance practice (including querying languages).
Apply knowledge of data modelling and management concepts to design, develop and critically
evaluate an information system within a chosen field of interest.
, Contents
Table Of Figures...........................................................................................................................................2
Scenario.......................................................................................................................................................3
Question 1 – Use Case.................................................................................................................................3
Diagram:..................................................................................................................................................3
Description:.............................................................................................................................................4
Question 2 – Entity Relationship Diagram/Model.......................................................................................5
Diagram:..................................................................................................................................................5
Description:.............................................................................................................................................5
Question 3 – Tables.....................................................................................................................................7
SQL Query for creating tables:.................................................................................................................7
Description:.............................................................................................................................................8
