Implement and submit adequate documentation

Assignment Help Other Subject
Reference no: EM132201205

Study the 'Ski-Italia Expeditions' case study carefully and then submit the following:

(1) An Entity-Relationship model, including attribute list.
You will have to make judgements as to what level of detail is appropriate.

(2) Normalise (to third normal form) the Course-Details form and the Customer Booking form separately. Show all the steps clearly. Now consolidate the entities by eliminating redundancies and then produce a final list of entities.

(3) Implement and submit adequate documentation for the following:

(a) Create and populate just those database tables which correspond to the normalised entities found in part (2). Submit Oracle scripts for each table, showing its description and its contents.

(b) Implement the following functionalities:

F1 - create a new customer and enrol him on a course
F2 - create a family of four and enrol them all on the same course
F3 - ability to change course information
F4 - ability to remove retiring staff from the system

(c) Develop the following queries:

Q1 - for a particular course, a list of all students currently enrolled, followed by a count of these students.
Q2 - for a member of staff, list his schedule.
Q3 - for a particular customer, show his booking details.

(d) Develop two additional queries (Q4 and Q5) which you judge will be useful in this context. Give a clear textual description of what each of your two queries is supposed to show. Use your judgement as to what information the queries should contain and how they should be formatted.

(4) Write a business report for Susan Holder which includes:
An explanation of your system;
The direct benefits to Susan of your database;
Future possible enhancements to the database system, with timescales;
Your recommendations on how her business can make effective use of management information.

Section 1:

The E-R model with attributes and relationships. You can draw the model using any tool you wish, including hand-drawn.
The results of your normalisation - show all normal form stages
Include any supplementary descriptions/notes/assumptions/discussion to strengthen your proposed design of the system.

Section 2:

Your CREATE TABLE commands for the tables in your system.
All the INSERT commands you have used to place data into those tables.
Code for F1 and output
Code for F2 and output
Code for F3 and output
Code for F4 and output
Code for Q1 and output
Code for Q2 and output
Code for Q3 and output
Code for Q4 with output and rationale
Code for Q5 with output and rationale.
Include any supplementary descriptions/notes/assumptions/discussion to strengthen your implementation of the system.

Section 3:
Your formal business report.

Attachment:- Case Study.rar

Verified Expert

In this assignment, I have studied about given case studied and write a report on the database management system.Here I have used Oracle developer software and I have create query on the create table and also write query.Here I have create entity relationship diagram and normalize database table.

Reference no: EM132201205

Actual production cost-determine cause of variances

At the start of the year, Frigicor estimated that the company would produce 480 refrigeration units during the year (40 per month).Annual fixed overhead costs were estimated t

Briefly describe the ethical dilemma or issue

Briefly describe the ethical dilemma or issue. Referring specifically to the "Principles of the Ethical Practice of Public Health," identify principles that should be applie

Role of american ideals in us national security policy

What role should America's ideals play in its national security policy? Include historical, current, and hypothetical cases in the analysis.

Discuss some of the problems of eye-witness accounts

Imagine that you were involved in a legal case in which an eyewitness claimed that he had seen a person commit a crime. Based on your knowledge about memory and cognition fr

Effect on consumers and suppliers of rental property

Explain the purpose of rent control and the intended effect on consumers and suppliers of rental property. Does rent control achieve its purpose?

How the rate of behavior is reflected in cumulative record

What are the principal similarities between within-subject and between-subjects design? Distinguish between speed, rate and latency. Explain how the rate of behavior is reflec

Identify a minimum of two neuropsychological tests

Identify a minimum of two neuropsychological tests Dr. Binet is likely to administer and explain why the tests were chosen. Justify the tests based on their validity and relia

Side in moral debate and carefully both sides of argument

he case study for which is found in Ethical theory and Business 9th edition, chapter 8 case 3. The goal of the paper is to give a short summary of the case study, choose a s


Write a Review

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd