Q1) Draw the ER Diagram for the scenario below. The company database keeps track of company's employee, department and projects. We store Employee's name, ssn, address, salary, gender, date of birth and age. An employee is assigned to one department, but may work on several projects which are not necessarily controlled by the same department. A particular employee manages the department. Each department has a unique name, unique number and several locations. The department controls number of projects each of which has a unique name, unique number and a single location. We want to keep track of the dependents of each employee for insurance purpose. We keep each dependent's first name, sex, birth date and relationship to employee.

Q1) Draw the ER Diagram for the scenario below. The company database keeps track of company's employee, department and projects. We store Employee's name, ssn, address, salary, gender, date of birth and age. An employee is assigned to one department, but may work on several projects which are not necessarily controlled by the same department. A particular employee manages the department. Each department has a unique name, unique number and several locations. The department controls number of projects each of which has a unique name, unique number and a single location. We want to keep track of the dependents of each employee for insurance purpose. We keep each dependent's first name, sex, birth date and relationship to employee.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Requirement analysis: Course evaluation must have a student, the students relation contains a unique student id, full name for each student, email address, phone number, address and date of birth. For each course, the courses contain course id, course name and credit. Each student can take many courses. For each Instructor, the instructors contain id, name and email. Each instructor can instruct many courses. For each section, the sections contain section id, year and semester. Students are able to evaluate the current courses. ER-diagram: Please complete the ER diagram using Microsoft word. Instructor ID Full name Email Student ID Full name Email Phone number Address Date of birth Course ID Course title Description Credit Section ID Year Semester Please Complete the diagram on MS word.
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. The table below shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT(ProjectID, EmployeeName, EmployeeSalary)
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.
Create a class diagram for the Sports Physical Therapy database, as shown in Figures 1-21 through 1-24 in Chapter 1. If you need to make any assumptions when preparing the diagram, document those assumptions.
Draw 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…
pls help me : Draw an ER diagram according to the following requirements:Database to manage daily medical examination and treatment in the hospital (not interested in treating inpatients):- The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department- The patient when he comes to the doctor will be created a patient record if it is the first visit- Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse.- The doctor may ask the patient to perform tests, x-rays, endoscopy, ....- After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any- Patients can buy medicine in the hospital pharmacy or buy it outside
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…
Task 1: ER diagram for give scenario Consider building a database for a shopping mall with requirements as follows:  Each product of the shopping mall has a unique project No, and also has a name, a supplier name, a category, a purchase price and a selling price.  Products need to be supplied from suppliers. Each product has one supplier, but a supplier may supply many products for the shopping mall.  Each supplier has a supplier name and address.  A purchase order for product from a supplier has a unique order No, and a date. The order specifies one or more products and their quantities required for a product.  A sales order for product to customers has a unique order No, and a date. The order specifies one or more products and their quantities required for a product  The shopping mall has warehouses. Each warehouse has a warehouse number, an address and a contact phone number. Each warehouse has shelves to store products. Each shelf has a shelf-number and a capacity. The shelf…
Please 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.
Create a diagram for a database with at least 5 tables. This should show your table names and column names. Show the relationships between the tables. Write a statement explaining your database design (why did you use the tables that you did). Create a database in Access based on your diagram. Include all tables in your diagram. Tables should each have a minimum of 5 rows. Create 5 SQL statements using your database. At least 2 of these should be manipulation statements (insert, update, etc). The others should be select statements. Explain what your sql statements do and how they would be useful to your database.
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary)
Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT