Create schema ddl statements to build your database

Assignment Help Database Management System

Reference no: EM133857858

Objectives

This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessmentis designed to reinforce the lecture material and give students practice at applying Database design techniques, as well as providing a relational schema using DDL statements and relational DML statements to demonstrate sophisticated access of the Database to be built.

Group Assignment Case Study
This assessment will be completed in groups of 4 students from the same class. Groups will be formed within the first 2 weeks, and students will be expected to work within these groups for the remainder of the semester on the group case study.

Each group needs to choose a particular type of Information System, research the storage requirements then design and build a possible database for that system. For instance, a group may choose a POS system for a supermarket, a small online savings bank, a stock management system for a financial firm etc.

The deliverable should consist of four parts, detailed as follows:

1. Requirement specification
Your group must provide an overview of the selected system and specify its requirements. These requirements should directly relate to the tasks outlined in the subsequent three parts.

2. Database ER Model
The ER Model should represent the database structure you plan to build for the group case study. It must be presented using Crow's Foot notation and accurately reflect the database to be built. The model should provide a realistic depiction of the data requirements for the chosen system and include at least 10 entity types.

3. Database Schema DDL statements
You are required to create Schema DDL statements to build your database. Your tables should include all appropriate primary and foreign keys, as well as any relevant constraints.

4. Sophisticated DML statements
Youare required to construct SQL INSERT statements to populate all your tables with initial data, ensuring that each table contains at least

5 rows. You have the freedom to choose appropriate data for insertion. Additionally, you must create 5 SQL statements to demonstrate sophisticated data access. These statements must involve joins between multiple tables (Inner Joins only are acceptable). The test data should be sufficient to effectively demonstrate the use of your SQL statements.

Reference no: EM133857858

Questions Cloud

Identify two tips for engaging in advocacy work : Resources and identify two tips for engaging in the advocacy work you plan to do in your future professional practice.

Which instruction is essential for the nurse to teach parent : The physician had ordered rectal diazepam for a 2-year-old boy with status epilepticus.? Which instruction is essential for the nurse to teach the parents?

What is the cause of bilateral macular oedema : What is the cause of bilateral macular oedema? How can one differentiate between papilloedema and a tilted disc on fundus examination?

What is a newly emerging/re-emerging disease : Discuss factors contributing to newly emerging or re-emerging infectious diseases and provide at least 2 examples.

Create schema ddl statements to build your database : Create Schema DDL statements to build your database. Your tables should include all appropriate primary and foreign keys, as well as any relevant constraints

Certificate III Early Childhood Educator : provide an example of how this informs your work in your role as a Certificate III Early Childhood Educator.

Discuss health care culture : Discuss health care culture and describe how Christian worldview (CWV) can be used to improve ethical practices.

Hospital acquired infection : If you were to go to a typical hospital in Boston, which adverse event are you most at risk of? Hospital acquired infection

Explains the positive outcomes : Explains the positive outcomes that will occur if the issue is addressed and negative outcomes

User Account

All Pages