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: