Need computer science help with DBM 502 - Normalization of data

Dec 7th, 2015
Price: $30 USD

Question description

Hi Tutors,

This is attached to a team assignment.  My portion this week is to discuss normalization of data.  I am looking for someone that is knowledgeable in database and understand what normalization is and what it does.  I have attached as much information that I hope you need.  If there is more information that is need please ask immediately.  Please review links this provides all information that we have done thus far.... listed below is the assignment and I have underline what I am asking for assist with today.


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. ---------------this is the focus only---------- TUTORS
  • 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.
  • 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) Alchemist
School: Duke University

Studypool has helped 1,244,100 students

Review from student
" Goes above and beyond expectations ! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1831 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