Question

In: Computer Science

Draw an ERD with the following information: You are a database consultant with Ace Software, Inc.,...

Draw an ERD with the following information:

You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to discuss their business and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore, there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices for them are based on the quantity of their shipment and the past business they have done with each company. The price of a DVD for a movie might be different from the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors and at different wholesale prices. Each video and DVD has a unique identification number that The owners assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number. The owners assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to the owners, and the information from these catalogs must be included in the database. The owners need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion, there are discount prices for specific movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the Academy Awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. The owners need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc. There must be no limit to the number of video and/or DVD copies of a movie that the owners can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and Academy Awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

Solutions

Expert Solution

`Hey,

Note: Brother if you have any queries related the answer please do comment. I would be very happy to resolve all your queries.

Kindly revert for any queries

Thanks.


Related Solutions

Draw the corresponding ERD for the following Employee Database: Employee (emp_id, first_name, middle_name, last_name, date_of_birth) Dept...
Draw the corresponding ERD for the following Employee Database: Employee (emp_id, first_name, middle_name, last_name, date_of_birth) Dept (Dept_id, Dept_name, Building) works (emp_id, dept_id, hours) Emp_phone (emp_id, phone_num) Note: Please I need a short answer only on paragraph and simple words.
Draw a complete ERD of a database design to meet their needs First Urban Rescue (FUR...
Draw a complete ERD of a database design to meet their needs First Urban Rescue (FUR ) takes in cats and dogs that are no longer wanted in their old home , and tries to find them new homes . For each pet taken in by FUR , the pet is given a name if it doesn't already have one . The breed , name , approximate age , height , weight , and date arrived at FUR is recorded...
Draw the ERD in Chen notation corresponding to the following spec: Sailors are identified by an...
Draw the ERD in Chen notation corresponding to the following spec: Sailors are identified by an sid, having a name, age, and rating Boats are identified by a bid and also have a name and a color. Sailors reserve boats on a given date. Every sailor reserves a boat at some time
2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is...
2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests. 3. Visit a Web site that allows customers to order a product over the Web (e.g., Amazon.com). Create a data model that the site...
case study 1.    Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify...
case study 1.    Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys). 2.    Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). case: HELP is a voluntary organization that provides aid to people. Based on the following brief description of operations, create the appropriate fully labeled Crow’s Foot ERD. Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The...
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company has many divisions. Each division operates many departments, but each department is operated by one division. b). A department employs many employees but not more than 100. c). Each employee is employed...
You have been given the following specifications for a simple database about the requests for software...
You have been given the following specifications for a simple database about the requests for software that staff members make for their units (note that primary keys are shown underlined, foreign keys in bold). You should run your SQL to demonstrate that it works correctly, and paste in the statements used plus the output from Oracle. LAB (RoomNo, Capacity) SOFTWARE (SoftwareID, SoftwareName, Version) REQUEST (SoftwareID, RoomNo, RequestDate, TeachingPeriod, Progress) Based on the table specifications provided, answer the following questions. Each...
You have been given the following specifications for a simple database about the requests for software...
You have been given the following specifications for a simple database about the requests for software that staff members make for their units (note that primary keys are shown underlined, foreign keys in bold). You should run your SQL to demonstrate that it works correctly, and paste in the statements used plus the output from Oracle. LAB (RoomNo, Capacity) SOFTWARE (SoftwareID, SoftwareName, Version) REQUEST (SoftwareID, RoomNo, RequestDate, TeachingPeriod, Progress) Based on the table specifications provided, answer the following questions. a....
1- Paper evaluation scenario a) Draw an ERD for the following relational schema: STUDENT (STD_ID, STD_First_Name,...
1- Paper evaluation scenario a) Draw an ERD for the following relational schema: STUDENT (STD_ID, STD_First_Name, STD_Last_Name, STD_Admit_Semester, STD_Admit_Year, STD_Enroll_Status) PAPER (PP_ID, PP_Title, PP_Submit_Date, PP_Accepted, PP_Type) The two entities are related with the following business rule: • Each student may write many papers Explain your choice of minimum and maximum cardinalities. b) Extend the existing ERD with an EVALUATOR entity. The job of the evaluator is to grade each paper. The following business rules apply: • Each paper is evaluated...
Draw an ER diagram and write a database design outline for the following prompt: You run...
Draw an ER diagram and write a database design outline for the following prompt: You run a coaching service to help high school students prepare for the SAT exam. You have a staff of coaches, each of which has an employee ID, an hourly rate (such as $20 per hour), and personal information consisting of their first name, last name, middle name/initial, address information, phone number, mobile phone number, and e-mail address. For each high school student, you want to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT