Data Modelling and Management
Data Modeling, Management and Governance
Assignment No.1
Submitted By:
Banner ID:
Couse Code:
Submitted To:
Topic: Data Modelling and Management
Dated: 22/11/21
1
, Data Modelling and Management
Table of Contents
Scenario:......................................................................................................................................................3
Use case Diagram:.......................................................................................................................................4
Entity Relation Modeling Diagram...............................................................................................................5
SQL Database:..............................................................................................................................................6
Statements to create Tables....................................................................................................................6
Club members......................................................................................................................................6
Staff members.....................................................................................................................................7
Sports class..........................................................................................................................................7
Activity Booking...................................................................................................................................8
Activity.................................................................................................................................................8
Instructor.............................................................................................................................................8
SQL Queries.............................................................................................................................................9
View current Booking..........................................................................................................................9
Current weekly activities......................................................................................................................9
Design Decisions..........................................................................................................................................9
Framework for design decision....................................................................................................................9
1- Goals....................................................................................................................................................9
2- Context..............................................................................................................................................10
3- Problem.............................................................................................................................................10
4- Solution.............................................................................................................................................10
5- Question............................................................................................................................................10
Issues and challenges Faced......................................................................................................................10
2
Data Modeling, Management and Governance
Assignment No.1
Submitted By:
Banner ID:
Couse Code:
Submitted To:
Topic: Data Modelling and Management
Dated: 22/11/21
1
, Data Modelling and Management
Table of Contents
Scenario:......................................................................................................................................................3
Use case Diagram:.......................................................................................................................................4
Entity Relation Modeling Diagram...............................................................................................................5
SQL Database:..............................................................................................................................................6
Statements to create Tables....................................................................................................................6
Club members......................................................................................................................................6
Staff members.....................................................................................................................................7
Sports class..........................................................................................................................................7
Activity Booking...................................................................................................................................8
Activity.................................................................................................................................................8
Instructor.............................................................................................................................................8
SQL Queries.............................................................................................................................................9
View current Booking..........................................................................................................................9
Current weekly activities......................................................................................................................9
Design Decisions..........................................................................................................................................9
Framework for design decision....................................................................................................................9
1- Goals....................................................................................................................................................9
2- Context..............................................................................................................................................10
3- Problem.............................................................................................................................................10
4- Solution.............................................................................................................................................10
5- Question............................................................................................................................................10
Issues and challenges Faced......................................................................................................................10
2
