University | Singapore University of Social Science (SUSS) |
Subject | ICT321: Database Systems: Modelling and Design |
Section A: Database Analysis: Modelling Data
Consider the following ER diagram.
Tasks:
- When converted to a Relational Schema
- How many Foreign Keys will exist in the Task relation?
- How many Foreign Keys will exist in Project relation?
- Consider the Project Relation
- What is the name of the Foreign Key in this relation?
- Would this foreign key be allowed to have Null values?
- Consider the Task Relation
- What is the name of the Foreign Key in this relation?
- Would this foreign key be allowed to have Null values?
- Imagine that you now want to build the database based on the Relational Schema
- Which table would you have to create first? Leader, Project, or Task?
- Which table would you have to create the second? Leader, Project, or Task?
- Which table would you have to create last? Leader, Project, or Task?
- Explain the relationship between
- Task and Employee by reading Left to
- Task and Employee by reading Right to
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Native Singapore Writers Team
- 100% Plagiarism-Free Essay
- Highest Satisfaction Rate
- Free Revision
- On-Time Delivery
Section B: Database Design: Logical Database Design And SQL
Consider the following ER diagram.
Tasks:
- Convert this ERD to a Relation/Relational Schema. Indicate all PKs and FKs.
- What is the PK of ENROLMENT?
- Write the SQL statement to create a student: STU101, Henry Bloggs
- Write the SQL statement to create a subject: DDMG, Database Design, and Modelling?
- Write the SQL statement to enroll Henry into Database Analysis and Design?
- Write the SQL statement for the following scenarios:
- After doing very poorly in the Final Exam, Henry scores an “N” (a fail), update his record.
- Six months later, Henry sits another exam for HIT1402 and obtains a “D” (a Distinction)
- Can this database design record the fact the Henry scored an “N” in one semester and then a “D” in the next semester? Why?
Section C: Case Study – Normalization
The PSB Sudoku Championships
“The PSB Sudoku Championships” are about to take place. A number of competitors will compete in the championships. Each competitor has a unique competitor id and a name. A number of Sudoku Puzzles have been generated for the championships. Each puzzle has a unique number and a Grade (such as Easy, Hard, Diabolical).
E.g. Puzzle No: P222 Grade: Hard
During the championships, a puzzle is simultaneously given to a number of competitors. As each competitor completes a puzzle his/her time is recorded. The organizers of the championships want to be able to produce reports such as these:
The organizers of the championships provide you with the following sample report:
Tasks:
- Create an ERD solution based on the above narrative.
- Convert the ERD to a relational schema.
Making a database assignment is now easy with Singapore Assignment Help. Hire online homework helpers for writing (ICT321) database design & modelling assignments. Our writers are master in this subject and they provide the best assessment answers to SUSS university students at a very affordable price. If you work with our professionals then it would help increase your potential and make the subject relatively easier and interesting for you to learn and make assignments about.
Looking for Plagiarism free Answers for your college/ university Assignments.
- ESG in Maritime Industry Assignment : Literature Review on Environmental, Social and Governance Practices
- CVE2332 Seepage and Flownet Analysis Assignment : Singapore River Cofferdam Case Study for Cost-Effective Sheet Pile Design
- DSWSH MC2 Electronic Security Assignment: Protection in Depth Plan for American International School (AIS) Singapore
- 6WBS0035/6 Digital Strategy Presentation Assignment: MNC Innovation Proposal for Global Growth
- PS6004EFA Project Assignment : Individual Research-Based Dissertation on Business and Management Topics
- Principles of Management Assignment 3 Report: Strategic & Ethical Analysis of MNC or SME Company
- Project Management Assignment: 1-Day Corporate Sports Tournament Planning
- Managing Across Cultures Assignment 2: Case Studies on McDonald’s, Fiat & Workplace Stereotypes
- WEB301 Green Plan 2030 TMA Report: Engaging Singapore’s Youth for a Sustainable Future through Online & Offline Communication Strategies
- Serial Position Effect Assignment: Quantitative Psychology Study on Memory Recall