Develop a database system to keep track of product inventory

Assignment Help Database Management System

Reference no: EM132294313

Question: 1. You are asked to develop a database system to keep track of product inventory for an online shopping website, PreownedDVDs.com. It sells used DVDs (movies, TV series, music videos). Regardless of the DVD content categories, the company wants to keep track of previous owner, initial DVD release date and retail price, purchase date and condition, and the suggested used-sale price. In addition, it wants to catalog some unique information for each DVD category. This includes:

directors, writers, stars, and synopsis for movies;

creators, stars, episodes for TV series; and

directors, producers, casts, and music titles for music videos

The number of directors, stars and so forth can be just two, given the website does not show their comprehensive lists. Each DVD title has multiple used DVDs for sale. For each DVD title, the company wants to know how many DVDs are available for sale as well.

2. Based on the above case, draw a 3NF ER diagram. For each entity, attributes can be shown as short-hand text notation, attribute names inside the entity box, or bubbles connected to the entity (see the attached examples). The number of attributes can be a representative few unless the case is explicitly requiring.

Implement database designs using your CDM SQL Server account. Submit the screenshots of the database table designs and the table relations view. Make sure that the screenshots are not too small to read. Use ALT+Fn+PrintScrn (Win10) to capture the screenshots.

Reference no: EM132294313

Questions Cloud

How positive and negative externalities could affect : Describe how positive and negative externalities could affect the efficiency with which governments can allocate their resources to provide.

Write a program and print the ages on-screen : Instructions: Write a program and flowchart. The program should store the ages of six of your friends in an array. Store each of the six ages using.

Write a program and flowchart to store numbers in an array : Write a program and flowchart. The program should ask the user for the average temperature in each of the last 12 months. After the user has entered.

Create a solid supply chain strategy for south america : Create a slide visual presentation with speaker notes for each slide and cite at least one reference outside of course textbook if possible.

Develop a database system to keep track of product inventory : HW4IS422 You are asked to develop a database system to keep track of product inventory for an online shopping website, PreownedDVDs.com. It sells used DVDs.

How well has the firm performed recently compared to rivals : How well has the firm performed recently compared to rivals? Has it outperformed rivals or underperformed them? Why?

What are the major obstacles you face in achieving your goal : Is your goal Achievable, and why? What are the major obstacles you face in Achieving your goal? How do you plan to overcome these obstacles?

Create a simulation model to investigate her concerns : Bristowe has asked for your advice in evaluating the current phone reservation system. Create a simulation model to investigate her concerns.

At what points you think their data is at the highest risk : Discuss, in 500 words, how you would advise your current employer to use encryption to reduce the vulnerabilities of their data at rest.

User Account

All Pages