Explain the history and development of database technologies

Assignment Help Other Subject

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

Reference no: EM132760441

Questions Cloud

Assumptions of experimental analysis of behavior : Explain the Six attitudes/assumptions of Experimental Analysis of Behavior and the Seven Dimensions of Applied Behavior Analysis

What are the pros and cons of insisting : What are the pros and cons of insisting that the entire family attend the initial consultation? What would you do if you learned that some of the family members

Cancellation rates of families scheduled for therapy : How can a therpist cut down on the no-show and cancellation rates of families scheduled for therapy.

What are the main educational theories : What are the 5 main educational theories?

Explain the history and development of database technologies : Explain the history and development of database technologies and the emergence of the relational database model and SQL.

POPP5051 Airline Operations and Marketing Assignment : POPP5051 Airline Operations and Marketing Assignment Help and Solution, De Montfort University - Assessment Writing Service

Differences between unipolar and bipolar mood disorders : What are the primary differences between unipolar and bipolar mood disorders? Treatment options for each disorder, including both medications and non-medication

How does your personality type influence stress : How does your personality type influence your stress? How has your scores influenced your current stress level?

Case studies of specific deductions and tax liability : Identify and critically analyse taxation issues and Interpret the relevant taxation legislations and case law - Apply taxation principles to real life problem

User Account

All Pages