Applying database design techniques

Assignment Help Database Management System

Reference no: EM133857988

Objectives
This assessment item relates to the unit learning outcomes as in the unit descriptor. This assessment is 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.

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. Hire best assignment help service online!
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:
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.
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.

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.

Sophisticated DML statements
You are 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. These statements should be included in a script and presented in class to your tutor.

Finally, your group is required to prepare a single document in Microsoft Word format. This document should contain a cover page and the four parts mentioned above. Ensure that the SQL statements for Parts 3 and 4 are included.

Reference no: EM133857988

Questions Cloud

What is rationale behind having to take certain drugs used : What is the rationale behind having to take certain drugs used in psychiatry weeks before patients can see effects of the medication?

How many mls will the nurse draw-up : Order: Methlyprednisolone 1.4mg/kg IV daily Available: Methylprednisolone 250mg/2mL Patient weight: 78.3kg. How many mls will the nurse draw-up?

How many mls will the nurse give every fifteen seconds : Order: Bumex 0.8 mg IV Available: Bumex 0.4mg/mL If the dose is going to be given over 2 1/2 minutes, how many mls will the nurse give every 15 seconds?

Why eriks recovery snack did not provide with enough energy : In your own words, explain why Erik's recovery snack did not provide him with enough energy. You are expected to share at least 2 reasons.

Applying database design techniques : Applying Database design techniques, as well as providing a relational schema using DDL statements and relational DML statements to demonstrate sophisticated

What is the new concentration of the meloxicam solution : What is the new concentration of the meloxicam solution? What is the new volume that you would inject in cc?

Summary of each of these reimbursement methodologies : Give a summary of each of these reimbursement methodologies. IPPS (inpatient prospective payment system), OPPS ( Outpatient prospective payment system).

How the theories work well with your own personal philosophy : Describe how the theories work well with your own personal philosophy. Incorporate how your metaparadigm will incorporate into the holistic nursing care plan.

Describe how you see the health reform : Describe how YOU see the health reform. How YOU like to see our health care system in 5, 10, 25 years? What needs to be done to make YOUR dream to come through?

User Account

All Pages