Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer using LucidChart please. Thanks Data Modeling Draw a complete ERD to support the needs described below. The diagram should be complete with all entities,

Answer using LucidChart please. Thanks

image text in transcribed

Data Modeling Draw a complete ERD to support the needs described below. The diagram should be complete with all entities, attributes, relationships, participation and connectivity friend of st opened a media recovery operation. Many people find that they have photos and A yours has ecordings saved on media that is outdated and often damaged, such as VHS tape, Betamax recordings, film slides and lomega Zip Drives. Your friend's business will extract the photos and recordings from the outdated media and provide them in newer formats. The original media is often destroyed in the process so it is not returned to customers after processing. She wants you to create a database system to help her run the business The basic processing is straightforward: A customer places an order for processing when they drop off the original media. The technician taking the order records some basic data on the customer. If this is a new customer, then the customer is assigned a customer id number and the following information is recorded (if this is a returning r, the information is verified as current): name, address, and phone number. Only customers that h placed orders are kept in this system. Each order is given an order number, and the date the order is placed must be recorded. Every order must be associated with one and only one customer The technician also records some information about the original media as well. Each media item is labeled with an id tag that has an id number so it can be tracked in the system. Also, the media type (VHS, Beta, Zip, etc.), and a sentence or so of description of the condition of the media (e.g., "Dirt in the spindle, with a crack in the tape shield.") are recorded. The technician also records which services the customer purchases for each media Processing services available at this time include "QuickJPG", "Full HD MPEG", and "CompleteJPG" amon others. Your friend may expand with new options in the future. A customer may purchase many different servic for each original media in a single order. For example, a single order was placed by Marc Garcia on May 11th for processing 2 VHS tapes. For the first tape, the Marc wants both Full HD MPEG movie and QuickJPG st the second tape, the customer wants CompleteJPG. For each service, the name of the service, a brief description and the current price for that service are kept in the system. For example, the QuickJPG service has a description of Encode every 100h frame of video as photog OI raphic still image stored in JPG format", and a price of $10 Once the order has been taken by the technician, the media is placed in a roller tray to be processed on a first-in first-out basis. Media is normally processed within 24 hours of processed for several day receipt, although some media may no t be The system should track which technician takes the order. After all processing to be done on a media item is complete, a technician must quality check the results of all processing services performed on that media before the mnants of the media are discarded (once it is discarded, it discard the media is an important decisio check and approves discarding each media item, and the date that the discard approval is given. A 4-digit employee ID number identifies each technician. For all technicians, the technician's name (first, last, and middle initial) and date of hire are kept in the system. All technicians, even new hires that have never processed any media or taken an order, need to be included in the system. Note that each media item in a given order can be completed on different days and/or by different technicians. For example, the first tape brought in by Marc Garcia completes both "Full HD MPEG" and QuickJPG" on May 11th, and Brandi Wilkins approves discarding the remnants of that tape on May 11th. The second tape is processed with "CompleteJPG" on May 12th and discarding is approved by Will Francis on that date too late to fix any mistakes so making the call to n). Your friend wants to know which technician completes the quality

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Data Mining

Authors: Pang Ning Tan, Michael Steinbach, Vipin Kumar

1st Edition

321321367, 978-0321321367

More Books

Students also viewed these Databases questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago

Question

Compare the current team to the ideal team.

Answered: 1 week ago

Question

a. Do team members trust each other?

Answered: 1 week ago