ICT 105

ICT105 – Data Modelling and Database Systems Assessment 2- Designing and Implementing a Relational Database Overview The purpose of this assignment is to develop the student’s skills in designing and implementing a relational database for a given case study. Timelines and important information Percentage value of Task: 40% Assessment Type: Group Assessment (3-4 members in one group) Due: Week11, 05-Feb-2023 at 11.59 pm Please include SISTC’s assessment cover page at the beginning of the submitted work. Submitting your work late will attract a 10% reduction of mark for each day beyond the due date. A delay of more than 5 days will result in being granted a 0. The whole report should be 1000 words (+/- 10%) excluding personal reflection discussions and references Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment task: LO3. Interpret entity relationship diagrams to implement database LO4. Describe relational algebra and its relationship to Structured query language (SQL) LO5. Use of query language tools and techniques to obtain data and information from database. Assessment Details In this Assignment you are writing the several SQL queries on a relational Movie Database. The data in this database is from the IMDB website. Requirements Question 1. Write the SQL code to create the table structures for the entities shown in Figure1. The structure should contain the attributes specified in Figure1. Use data types that are appropriate for the data that will need to be stored in each attribute. Enforce primary key and foreign key constraints as indicated by the diagram.