Draw an EER diagram for the following description of a law firm:
Each case handled by the firm has s unique case number: a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plaintiffs, and the same plaintiff may be involved in many cases. A plaintiff has a requested judgment characteristic. A case is against one or more defendants, and the same defendant may be involved in many cases. A plaintiff or defendant may be a person or an organization. Over time, the same person or organization may be a defendant or plaintiff in cases. In either situation, such legal entities are identified by an entity number, and other attributes are name and net worth.
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
Modern Database Management (12th Edition)
- Draw an ER diagram that captures the following information: A book identified by (unique Id number, a title and one or more authors), A library identified by (unique name and adders), A borrower has a name and a unique ID code. The library service may own several copies of a given book. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. *arrow_forwardDraw a complete ER-diagram for the following case. A lecturer (having an ID, name and room number) is responsible for organizing a number of course modules. Each module has a unique code and also a name and each module can involve a number of lectures who deliver part of it. A module is composed of a series of lectures and sometimes lectures a on a given topic can be part of more than one module. A lecture has a time room and date and is delivered by a lecturer and a lecturer may deliver more than one lecture. Students, identified by number and name, can attend lectures and a student must be registered for a number of modules. We also store the date on which the student first registered for that module. Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor. Also show relational database schema including Primary and Foreign key constraints. (Please draw this on a paper)arrow_forwardDraw an E-R diagram for each of the descriptions below. Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…arrow_forward
- Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.arrow_forwardDraw an E-R diagram for the description below. Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model. Each piano model has an identification number and a name. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. Ebony and Ivory employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least one technician (identified by their employee number). Each technician has a set one or more specialties. Some technicians may not be responsible for inspection jobs. For each separate inspection, the company needs to record its date and a quality evaluation grade. The piano technicians have a hierarchy of reporting relationships: some of them have…arrow_forwardDraw an E-R diagram for the description below. Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model. Each piano model has an identification number and a name. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. Ebony and Ivory employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least one technician (identified by their employee number). Each technician has a set one or more specialties. Some technicians may not be responsible for inspection jobs. For each separate inspection, the company needs to record its date and a quality evaluation grade. The piano technicians have a hierarchy of reporting relationships: some of them have…arrow_forward
- Consider the following entity relationship diagram. Booking Employee Room Building • Booking ID • Employee ID • Building ID • Room ID • First Name • Room ID P • Name Description • Employee ID • Name Last Name • Date • Campus Zone • Email Address • Capacity • Start Time • Map Coordinates Phone • Bookable • End Time For each statement below, use the drop-down box to indicate whether it is true (answer 1) or false (answer2), according to the design decisions encoded in the ERD. Every booking is associated with exactly one employee. ✓ Every employee is associated with at most one booking. ✓ A building may contain no rooms that are recorded in the database. Each room may have many bookings. 1. True ✓ A room must have at least one booking. 2. False ✓ A booking can be associated with many employees. An employee may have no phone number recorded. ✓ A room must have its capacity recorded. ✓ A building is uniquely identified by its map coordinates.arrow_forwardDRAW AN ER DIAGRAM FOR THE GIVEN SITUATION The video rental company has several branches throughout the USA. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Each branch is given a branch number, which is unique throughout the company. Each branch has allocated staff which includes a Manager. The manager is responsible for the day to day running of the given branch. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company.Each branch has a stock of videos. The data held on a video is the catalog number, video number, title, category, daily rental, cost status, and the names of the main actors, and the director. The catalog number uniquely identifies each video. However, in most cases, there are several copies of each video at a branch, and the individual copies are identified using the video number. A video…arrow_forwardDesign: An (ER) and (relational Diagram) by showing as I am an owner of a car rental company website describing the following domain: I am the owner of the website, and I see the registered customers records I have through different car types and car rental Every rental operation has a start or end by day or KM Every car has a different price depending on its year production and model We have three rental types( Per Kilometers, monthly, daily) in different prices even though it was the same car Any one can enter his 'id' which includes ( Name, age, gender, address, city, Civil id), and this 'id' is the primary ket to all entities He would proceed to register for renting a car per his choice Then he will send the registrations form that I will analyze and contact him Every customer can rent only one car This choice has one car rental type based on the available listed cars in the registration The owner of that website has the "id" records and the registration database running its…arrow_forward
- Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes Order: has one or many items; half by member half by anonymous member (no member number)Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped. Order-Item (one of the 1600 products):to identify: useorder number as well as a small “item sequence number” (which is unique within each order). product number, quantity ordered and the actial "unit price paid" If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used. The average order includes 11 distinct order-items. Member (places 5 orders per month on avg):last name, given names, email…arrow_forwardPlease draw an Entity-Relationship diagram for the given below MOVIE database. The data requirements are summarized as follows: Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth). Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie. Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie. Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct). Production companies are identified by name and each has an address. A production company produces one or more movies.arrow_forwardPrepare an Entity Relationship Diagram for the application described in the following paragraph. Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees, projects and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning