College of Computing and Information Sciences
CSDB1102/ ITDB101 ntroduction to Database
Marks Obtained: E../15
Semester Fall
ASSIGNMENT
Issue Date: Tuesday, 30 OCTBER 2022
Submit date: Thursday, 22 Dec 2022
Important Instructions:
•
•
•
The assignment is a group assignment (Max 2)
Develop your own case scenario based on the topic assigned to your group.
For the case scenario, you must draw the corresponding Entity-Relationship diagram
(ERD).
After designing the ERD, you must design the corresponding relational data model.
Normalize the relations that you have designed, up to third normal form.
Design the ERD using ERDPLUS or any other ER drawing tool.
You have to submit the following things:
•
•
•
Case Scenario based on the topic assigned to the group
ER diagram
Relational data model
Normalized relations (up to 3NF)
SQL Command [create table, insert data, update data, select data]
PPT to explain your work.
The Academic Integrity and Plagiarism Policy:
You should be ready to prove the authenticity of your work. If any form of plagiarism/reproduction
of answers/work discovered, you will be awarded zero mark.
Late submission of the assignment:
Late submission of the assignment/project will lead to 10%-mark deduction per day from the total
mark of the assignment/project. Fridays & Saturdays are counted.
You are expected to cover the following outcomes
•
•
•
Explain data modeling/ conceptual design phase, types/levels of data models, and the
concepts of Entity Relationship (ER).
Analyze a case study and design a data model using ER diagram.
Illustrate relational data model and its components.
Modify an ER model into a relational database schema.
Apply normalization up to third normal form to improve the database design.
Apply SQL concept such as DML & DDL.
You are expected to practice the skills that are related to the following graduate attributes
•
•
“cholastic rigor & practical competence: creative thinking, problem solving, analytical
thinking, time management, dexterousness and knowledgeability.
Teamwork: collaboration, tolerance and flexibility, planning, organization and time
management.
Lifelong learning: research skills, critical thinking, inquisitiveness, goal setting,
commitment and adaptability.
Autonomy and Accountability: work independently, confidence, responsibility,
transparency, reliability and authenticity.
Innovation: imagination, aspiration, problem-solving, solution-integration, visionary and
perseverance
Marking Rubrics (15 MARKS)
REQUIREMENTS
CRITERIA
Case
scenario/problem
Completeness of case scenario
based on
the assigned topic
0% – 5%
6% – 20%
21% – 30%
>30%
Completeness and correctness of
the ER
Model
Completeness and correctness of
the relational data model
Correct normalized relations up
to 3ND
Create tables.
Insert at least 3 rows in each
table, use update command to
update data.
Use select to read data from the
table.
Originality of case
scenario
ER Model
Relational Data
Model
Normalized
relations
SQL DDL & DML
MARKS
TOTAL MARKS
ALLOCATED
ALLOCATED
1
1
1
.75
.5
0
2.5
1
2.5
2.5
3
3
5
5
2.5

Purchase answer to see full
attachment