Reference no: EM132760441
ICT200 Database Design and Development - Kings Own Institute
Learning Outcome 1: Explain the history and development of database technologies and the emergence of the relational database model and SQL.
Learning Outcome 2: Model business information requirements and produce a logical database design using entity relationship diagrams (ERD) and extended relationship diagrams (EERD).
Learning Outcome 3: Design, develop, test and prove the functionality of a database using MS Access and SQL.
Learning Outcome 4: Describe and carry out the necessary steps to develop an effective physical database design
Learning Outcome 5: Formulate, write and execute SQL queries in an SQL Server environment.
Learning Outcome 6: Explain the main functions of database administration and data warehousing.
Assessment
Assessment type: Group Project (Report, Demonstration and Presentation) - Problem Based Scenario to Design (ERD), Implement and Query a SQL Server Database Report 15% Presentation 5% Demonstration 5%.
Purpose: Students will demonstrate an understanding of the concepts they learnt in this unit by working a group to design, normalize, implement and query an SQL Server database according to a scenario provided to them. Students will answer questions pertaining to SQL Queries during their presentation and demonstrate by executing queries they might have written. This assessment contributes to learning outcomes d and e.
Assessment topic: Case Studies selected by students to be approved by tutor by week 8
Task details: Students will be provided a case study by week 7 for this assessment. An ERD, database, scripts for creating tables, views, triggers, functions, stored procedures, insert, update, alter, delete and successful query results as required in the case study will be assessed according to the marking criteria
Students will deliver a 15 mins presentation and demonstration of tasks they performed as a group in class during tutorial and explain their understanding and the approach they took to work on the assignment. This will be arranged in Week 10.
Students must create a data model using crow's foot notation in any tool of their choice, normalize the data from 1 NF to 3 NF and show each normalization with diagrams/tables and appropriate sample data to explain their understanding. Students will submit one group written report of 1,000 words detailing the tasks they carried out in the assignment. 3 to max 4 students can be in one group. This report will be due by the end of week 11.
The report requires a title page with student group members' names and student id. Students are advised to use group assignment cover sheet.
A brief introduction to the assignment can then be followed by the initial ERD, the Normalized version and the SQL statements developed as required in the case study. Report must be well-written, have in-text and detailed APA style referencing and presented professionally, containing:
1. Title page
2. Table of Contents
3. Introduction
4. Appropriate use of headings within report
5. Overall structure, presentation and formatting.
All group members must remain present for the demonstration in tutorial and must be able to explain the scripts written for the tasks outlined in case study.
Attachment:- Database Design and Development.rar