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

Good examples of advertising directed toward elderly consumers - Tone vs mood literary definition - Sooner okie irrigation and drainage - Autism alert card hampshire - Wileyplus accounting homework answers - What is the noble gas configuration for potassium - Discussion: Suicide, Stigma, and Substance Abuse-wk8-6212 - F5 vdi deployment guide - Low lying cloud name - Melissa owns the following portfolio of stocks. what is the return on her portfolio? - Monash engineering design 2 - Levett jones clinical reasoning cycle - Comprehensive Customer Analytics - Single equation regression model - Clinical Journal Assignment - John deere ac refrigerant capacities - K9 posse ain t nothin to it video - Madras motor neuron disease - Discussion week 8 - Christmas carols in other words quiz - English Comp 2 Week 2 - Hotel reservation system documentation doc - Emerging threats_6.1 - History revolutions study design - What does web 1.0 primarily offer - To cut into very small cubes of even size - Dry tamp cast stone - Forensic design assessments - Crazy domains email outlook settings - Project Week 1 10/28/2020 - Risk Management and Mitigation Planning - Mcgraw hill connect answers spanish - Cognitive humanistic and behavioral schools of thought - Aaron maldonado oregon - 16 riverview place murarrie - MGT312T Week. 2 Apply Self-Assessment Reflection - Spss output to word - Running to blocked state - Sunny coast baby and kids market - Things fall apart citation - Business Scandal - Roman hanging punctuation illustrator - Year 10 biology textbook - Wallace high school lisburn - School captain speeches examples - Hooded smile mitchell orval - Mgbr2 lewis dot structure - Convert k to k2o - Determination of hardness of water by edta titration method - Biological reviews of the cambridge philosophical society - Short paper - Chain smoking whiskey drinkin sob - LM 8: Interviews and ABA - Milton keynes college moodle - The warriner school teachers - M/shield 2 500ml 61354 - Reviewing your knowledge exercise 17 - What is a vivid verb - Unit 2 discussion board - Payroll accounting chapter 7 project solutions - Journey of the magi birth and death - Reflection Instructions - Art5 - Double sided arrow visio - Partner k950 fuel mix ratio - Annual report ratio analysis assignment - Local safeguarding children's board hampshire - Non nursing borrowed theories - Old mutual wealth risk profiler - Mi familia y yo hemos llevado una vida sana. (me alegro de que) - Foundation of finance, and the balance sheet - Uc davis work study - Ista 2a vs 3a - X 84 21 3 x 6 - Hclo4 aq koh aq - How to pronounce geert hofstede - Questions for finding forrester answers - Discuss the challenges involved in staffing operations in emerging markets - John clare fallen elm - How is holy orders performed - Operations and algebraic thinking lesson plans - Telecomm Network Security - How to always be imposter in among us - Frida kahlo material practice - Unit 6 Discussion – Debate: Privacy on the Job - Gumtree perth unwanted gifts - Developing project managers at global green books publishing - Critical asset risk management cbt answers - Canadian virtual assistant network - Case study - Health policymaking in the united states 6th edition free pdf - Current and projected free cash flows for radell - Enterprise risk management syllabus - C304 task 2 - Kenwood ts 590sg opinie - Airbus global market forecast - Nicky yazdi property advisors - Australia webometrics - Crime analysis strategies within Law Enforcement - Information technology for the health professions 5th edition