Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Happy cruise lines er diagram

30/12/2020 Client: saad24vbs Deadline: 7 Days

Assignment Grading Rubric


Course: IT234 Unit: 5 Points: 60


Copyright Kaplan University


Assignment 5 Outcomes addressed in this activity:


Design relational databases by converting entity-relationship diagrams into relational tables Perform the data normalization process Describe a variety of physical database design techniques ranging from adding indexes to


denormalization Course Outcomes: IT234-2: Analyze the systemic approaches that businesses use to acquire, store, and present data and transform it into information used to support business operations and decision making. Part 1 – Logical Design Disclaimer: The organizations and characters depicted in this exercise are fictional. Any resemblance to real organizations or individuals is purely coincidental. Video Centers of Europe, Ltd. is a chain of movie DVD rental stores. It must maintain data on the DVDs it has for rent, the movies recorded on the DVDs, its customers, and the actual rental. Each DVD for rent has a unique serial number. Movie titles and customer numbers are also unique identifiers. Assume that each movie has exactly one “star.” Note the difference in the year that the movie was originally filmed and the date that a DVD—an actual disk—was manufactured. Some of the attributes and functional dependencies in this environment are as follows: Attributes


DVD Number Manufacture Date Movie Title Star Year Filmed Length [in minutes] Customer Number Customer Name Customer Address Rental Date Return Date Fee Paid


Functional Dependencies DVDNumber MovieTitle DVDNumber Star DVDNumber ManufactureDate MovieTitle Star MovieTitle Length MovieTitle YearFilmed CustomerNumber CustomerName CustomerNumber CustomerAddress


Assignment Grading Rubric


Course: IT234 Unit: 5 Points: 60


Copyright Kaplan University


DVDNumber, CustomerNumber, RentalDate ReturnDate, FeePaid Source: Gillenson, M. (2011). Fundamentals of database management systems, second edition. Hoboken, NJ: John Wiley & Sons. Using the attributes and functional dependencies above, consider the following; For each of the following tables (a,b,c,d,e), 1. First write the table's current normal form (as 1NF, 2 NF, or 3 NF). 2. Then, take those tables that are currently in 1 NF or 2 NF and reconstruct them as well structured 3 NF tables. Primary key attributes are underlined. Do not assume any functional dependencies other than those shown.


a. Movie Title, Star, Length, Year Filmed b. DVD Number, Customer Number, Rental Date, Customer Name, Return Date, Fee Paid c. DVD Number, Manufacture Date, Movie Title, Star d. Movie Title, Customer Number, Star, Length, Customer Name, Customer Address e. DVD Number, Customer Number, Rental Date, Return Date, Fee Paid


Part 2 – Physical Design Consider the following relational database for Happy Cruise Lines. It keeps track of ships, cruises, ports, and passengers. A “cruise” is a particular sailing of a ship on a particular date. For example, the seven-day journey of the ship Pride of Tampa that leaves on June 13, 2003, and is a cruise. Note the following facts about this environment:


Both ship number and ship name are unique in the SHIP Table. A ship goes on many cruises over time. A cruise is associated with a single ship. A port is identified by the combination of port name and country. As indicated by the VISIT Table, a cruise includes visits to several ports and a port is typically included


in several cruises. Both Passenger Number and Social Security Number are unique in the PASSENGER Table. A


particular person has a single Passenger Number that is used for all of the cruises that she takes. The VOYAGE Table indicates that a person can take many cruises and a cruise, of course, has many


passengers.


Assignment Grading Rubric


Course: IT234 Unit: 5 Points: 60


Copyright Kaplan University


Source: Gillenson, M. (2011). Fundamentals of database management systems, second edition. Hoboken, NJ: John Wiley & Sons. Analyze each of the following situations and, using the physical database design techniques discussed in this unit, indicate how you would modify the logical design shown to improve performance or otherwise accommodate it.


a. There is a need to list cruises by cruise number but there is also a periodic need to list all of the cruises in order by start date.


b. There is a frequent need to quickly retrieve the data about a cruise together with the data about the ship used on the cruise.


c. There is a frequent need to quickly retrieve cruise data based on departure date. d. Data about passengers from California must be accessed quickly and much more frequently than data


about passengers from anywhere else. e. There is a frequent need to quickly retrieve a list of the port managers of the ports at which the ship on


any particular cruise will stop. f. There is a frequent need to quickly find the total number of passengers who were on any particular


cruise. g. There is a frequent need to find the start and end dates of cruises as quickly as possible.


Assignment Grading Rubric


Course: IT234 Unit: 5 Points: 60


Copyright Kaplan University


h. There is a frequent need to find cruise data based on ship name. Hint: The Ship Name attribute is unique.


Directions: For this Assignment you will examine the methodology and considerations necessary for completion of a Logical and Physical Design. For both part 1 and part 2, examine the exhibits provided. Using your knowledge of the design process evaluate the exhibits and answer the questions provided. In a word document, copy each question and then directly underneath it provide your answer. Format the word document for maximum readability and clarity. Use a consistent font throughout. Arial 11, is preferred. Directions for Submitting Your Assignment: Compose your Assignment in a Microsoft Word document and save it as IT 234 YourName_Unit_5.doc and submit it to the Dropbox for Unit 5. Written Assignment Requirements: Written work should be free of spelling, grammar, and APA errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion. Please be sure to download the file “Writing Center Resources” from Doc Sharing to assist you with meeting APA expectations. Review the grading rubric below before beginning this activity. Assignment 5 grading rubric = 60 points


Assignment Requirements Points Possible


Points Earned


1. Each of the table's current normal form (as 1NF, 2 NF, or 3 NF) is indicated.


0–5


2. Each of the five tables has been properly reconstructed as well structured 3 NF tables.


0–15


3. A physical design solution is provided for the problem -- There is a need to list cruises by cruise number but there is also a periodic need to list all of the cruises in order by start date.


0–5


4. A physical design solution is provided for the problem -- There is a frequent need to quickly


0–5


Assignment Grading Rubric


Course: IT234 Unit: 5 Points: 60


Copyright Kaplan University


retrieve the data about a cruise together with the data about the ship used on the cruise.


5. A physical design solution is provided for the problem -- There is a frequent need to quickly retrieve cruise data based on departure date.


0–5


6. A physical design solution is provided for the problem -- Data about passengers from California must be accessed quickly and much more frequently than data about passengers from anywhere else.


0–5


7. A physical design solution is provided for the problem -- There is a frequent need to quickly retrieve a list of the port managers of the ports at which the ship on any particular cruise will stop.


0–5


8. A physical design solution is provided for the problem -- There is a frequent need to quickly find the total number of passengers who were on any particular cruise.


0– 5


9. A physical design solution is provided for the problem -- There is a frequent need to find the start and end dates of cruises as quickly as possible.


0– 5


10. A physical design solution is provided for the problem -- There is a frequent need to find cruise data based on ship name.


0– 5


Total (Sum of all points)


0–60


Less deduction taken for spelling, grammar and APA errors. Plagiarism is totally unacceptable.


Adjusted Total Points

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Helping Hand
University Coursework Help
Top Essay Tutor
Writer Writer Name Offer Chat
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Is sour an abstract noun - Apple iphone not made in america case study - What is the setting in the little match girl - Essentials of strategic planning in healthcare by jeffrey p harrison - Nor gate datasheet 7402 - Discussion board - Tmod register in 8051 - Making a phasing harness - Energy in food experiment hypothesis - First in first out perpetual inventory method - Positioning presentation mkt 421 - Hairy bikers eve's pudding - Economic problems - Sentiment Analysis Report - Topic 4: Policy and Environmental Issues - Going for oysters jeanie adams - Teaching emotion recognition autism worksheets - Automatic negative thoughts examples - Chords of stand by me - Union Representation Memo - Bertrand island roller coaster death - Negatives and positives rules - Wk 7 forum 2 Samuel - Chap. 6 Q MAC - What does homework mean on tik tok - Essay - Neopentyl bromide undergoes dehydrohalogenation - Erin brockovich case summary - Ict equipment list for office - CIS 348 Assignment 2: COPA and CIPA - What was the scoop deliverable and results of the project - The fourteenth goldfish movie - Under armour raw materials - Sketchup stl export plugin download - Psychology - Ch3co3h reaction with alkene - Proc sql format character - What is your belief about ultimate reality - Aacn essentials of baccalaureate education - Company that pioneered metal drivers in golf crossword - Percentage of copper in brass experiment - Mackillop family services mission - Cultural morality essay - Famous people who have achieved the american dream - What is the percent composition of ammonium nitrate - Liverpool council nsw contact - Define hess law of constant heat summation - Fun home chapter 1 pdf - Questions about Insurance - Hhmi lizard evolution virtual lab answers - How to say hello in st lucia - You are going to be assessed for: Your skills and knowledge using written and observation activities that apply to the workplace. Your ability to apply your learning. - Wireless Technology 3 - Algebra Talk - Network design proposal for hospital - Download the file below - El envía sangre (sends blood) al resto del cuerpo. - Bobcat code 9 21 - Good criminal justice questions - Simquick examples - Vector lab report physics - Boral weep hole covers - The basic aim of psychoanalytic therapy is to - IT incident response - Hp elitebook 820 g1 - The garden spot charlottesville virginia - Lse student union bar - Strategic Marketing 1 - Preparation of fluoride standard solution - Nt demerit points check - Gurula bird sri lanka - Volume of a troy pound of gold - Trigonometry of obtuse angles - Five elements of internal control accounting - 7th chord inversion symbols - Loma linda pharmacy school - NUR501- Discuss the interrelationship among theory, practice, and research. - Cultural artifact speech - What is a circle graph used for - Short nights of the shadow catcher discussion questions - Which of the following is an ethical concern of accountants - 0.0004 in scientific notation - Mental health and behavioral services. - A streetcar named desire 1995 cast - Virtual water quality lab - Unlike a perfectly competitive firm for a monopolistically competitive firm - Final p - Training at keller globe case study - Ap statistics quiz 6.3 c answers - Walmart inc takes on amazon com case study solution - Macroeconomics assignment 2 - How to avoid personal pronouns - Cadet centre for adventurous training - Rehau pex pipe specifications - Business law essay questions and answers - English - IT Leadership Styles - IT Risk Assessment Report - What does the triangle mean in naplan - Hughes wholesale cars toowoomba