Reference no: EM132527213
ICT 200 Database Design And Development - King's Own Institute
Assessment
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
Task details: Students will choose a case study and get it approved by their tutor by week 8 for this assignment. An ERD, database, scripts for creating tables, views, triggers, functions, stored procedures, insert, update, alter, delete and successful query results as requested in the case study will be assessed according to the marking criteria below.
Students must normalize the data from 1 NF to 3 NF and show each and every 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 in the end of week 11.
Students will also deliver a 15 mins presentation and demonstration of queries 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 and 11.
The report requires a title page with student group members' names and email, the assessment title and date. 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 used as required in the case study. Report must be well-written, have in-text and detailed Harvard 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
Attachment:- Database Design And Development.rar
|
Determine the number of units of kites that ocean city kite
: Ocean City Kite Company, Determine the number of units of kites that Ocean City Kite Company must sell in FY 2019 to meet this goal.
|
|
Develop evaluation program or policy for your intervention
: Select, design, and develop an intervention program for your identified public health problem. Develop an evaluation program or policy for your intervention.
|
|
CRM Technologies Build-Buy Analysis and Program Management
: You work for a large Boston based investment firm. They are currently using an older CRM (Client Relationship Management) system.
|
|
Describe the main product and consumer base
: Describe the main product, service offerings, and consumer base. Describe the main departments and their roles, including all major stakeholders.
|
|
Implement and query an sql server database
: 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
|
|
Compute the required sales units to achieve sales net income
: PCB Corp.Compute the required sales units to achieve its sales net income. Compute the required sales in units for target net income.
|
|
Technological revolution advances
: Elon-Musk donated $10 million to foundation called Future of Life Institute. What other concerns should public bear in mind as technological revolution
|
|
Write essay on social emotional development
: Compose a research-based essay focusing on Social Emotional Development, the Self and Identity, and Gender. This essay must be in APA format with a minimum.
|
|
Compute the margin of safety and the margin of safety ratio
: For Corb Company sales are $1,200,000 and break even sales are $840,000. Compute the margin of safety and the margin of safety ratio
|