Discussion
• 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.
• 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.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.