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

Questions Cloud

What is the value of test statistic : You decide to test your claim using publicly available registration records and a 0.05 significance level. What is the value of your test statistic?
Does the information in the readings convince you : In our first discussion we will start with the hot topic of how to choose news and the difference between real and fake news.
What impact is foreign trade having on gdp and us economy : The level and growth rate of real consumption spending for the first two quarters of 2018 and for all of 2017. What impact is foreign trade.
What are the principal problems that need to be resolved : What are the principal problems that need to be resolved before biomass (such as swithgrass) can become a viable energy source for cars and trucks?
Implement and submit adequate documentation : CC7174 – Database Systems with Professional Certification -
Does the order matter in the book selection : Mimi has eight books from the Statistics is Fun series. She plans on bringing two of the eight books with her in a road trip. (Show all work).
Write the equation showing the relationship : Suppose the return from the market portfolio when return from asset A is 0 is β0, and the increase in market return from a 1 unit increases in return.
What is the probability that the majority of the residents : If you visit 64 houses, what is the probability that the majority of the residents at the houses you visit will be in support of your candidate?
Explain the costs and benefits of leagues limiting entry : Explain the costs and benefits of leagues limiting entry. Use thedifferent revenue in two leagues (NHL, MLB, NFL, and NBA) to explain why the choice of stadium.

Reviews

Write a Review

 

Other Subject Questions & Answers

  Class is for fundamentals of interpersonal communication

Define and interpret this concept and explain under what conditions and in what relationships showing grace is appropriate and inappropriate.

  Accusations of witchcraft

In the past there were many horrors that passed as treatment. And the lobotomies, trepanning (holes in the head) and accusations of witchcraft were all associated with mental illness at one time or another.

  Do you think the affirmative action should be applied

Abigail Fisher contends that when she applied to the University of Texas. Do you think the affirmative action should be applied in any case? What do you think?

  How do innate factors and environmental factors interact

How do innate factors and environmental factors interact

  Description of the adult learners you have in mind

Plan a learning experience on a topic appropriate for a group of adult learners in a specific program or setting within the early childhood field. A description of the program or setting in which you would present the learning experience. A descrip..

  Disadvantages of utilitarianism and deontological theory

"Discuss the chief advantages and disadvantages of Utilitarianism and Deontological Theory. Think specifically about how the theories would work in a concrete situation. Provide a concrete example to support your response.

  Does your company use web conferencing software

If so, which software and how often? If not, would your company benefit from using this technology? Also provide a reference to cite your answer.

  Explain complete process of electroplating

Discuss two cases where Hess's law can be applied to calculate enthalpies of reactions that are difficult to measure directly

  How each strategy could assist jacob in reaching his goal

Explain how each strategy could assist Jacob in reaching his goal. In addition, discuss how you would involve Jacob's parents, and develop an activity from one of these three strategies that Jacob's parents can use at home.

  What does the given difference reflect for anthropologists

Distinguish between Culture (with a capital C) and culture(s) (with a lowercase c). What does this difference reflect for anthropologists?

  Presidents of the united states play many roles

Presidents of the United States play many roles. Using a news article from the last four weeks, demonstrate which is most important and why.

  The director of career advising at orange community college

1. a local real estate investor in orlando is considering three alternative investments a motel a restaurant or a

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