Database Management - Data storage

Dec 9th, 2015
FratBro23
Category:
Computer Science
Price: $20 USD

Question description

Assignment

Your Learning Team has been hired as database consultants for a start-up company that will stream movies over the Internet (similar to Hulu, Netflix, and others). The new organization requires one or more databases for Customer Information, Movie Information, and Supplier Information. At a minimum, the following attributes must be captured:

  • Customer: name, address, customer ID, credit card number and expiration, history of movies rented, "likes" (such as, genres, and movies the customer is interested in)
  • Movie: title, year, supplier ID (owner of movie), description of movie, statistics on movie rental frequency, rental cost
  • Suppler: ID, name, address, bank routing payment information

Create the documentation and databases for the following:

  • Conceptual design of the database(s)
  • Data analysis and requirements
  • Entity relationship modeling and normalization
  • Data model verification
  • Database design - justify use or non-use of distributed model
  • Logical design of the database(s)
  • Map the conceptual model to the logical model components.
  • Validate the logical model using normalization.
  • Validate the logical model integrity constraints.
  • Validate the logical model against user requirements.
  • Physical design of the database and description of security, performance, and backup and recovery processes. Include the following processes in your design:
  • Define data storage organization. **** Me ( this is what I need assistance with only **** How will this relate to what our service we are offering.
  • Define integrity and security measure.
  • Determine performance measures.
  • Define backup and recovery processes.
  • Prototype database(s). Use Microsoft® SQL Server® 2012 to create prototypes of the database(s) described in the physical design phase. At minimum, demonstrate use of the following SQL statements:
  • Create database
  • Create index
  • Create table
  • Alter
  • Delete
  • Insert
  • Join
  • Select

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Maryland
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
ddg82
Dec 11th, 2016
" Thanks, good work "
tinytim47
Nov 27th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
kenmwao2
Nov 25th, 2016
" Solid work, thanks. "
jestin7
Nov 18th, 2016
" This tutor is great! "
lilmoe415
Nov 5th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
dontuwannaknow
Oct 13th, 2016
" Excellent work as always thanks so much "
thargrow
Oct 4th, 2016
" Very Satisfied. "
SjSurvivor143
Sep 30th, 2016
" Thanks for the help. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1829 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors