The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. Each department controls a number of PROJECTs. Each project has a name, number and is located at a single location. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects. ER diagram??

The company is organized into DEPARTMENTs. Each department has a name, number and an employee who manages the department. Each department controls a number of PROJECTs. Each project has a name, number and is located at a single location. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects. ER diagram??

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 16RQ

See similar textbooks

Similar questions

Each publisher has a unique name; a mailing address and telephone number are also kept on eachpublisher. A publisher publishes one or more books; a book is published by exactly one publisher. Abook is identified by its ISBN, and other attributes are title, price, and number of pages. Each book iswritten by one or more authors; an author writes one or more books, potentially for differentpublishers. Each author is uniquely described by an author ID, and we know each author's name andaddress. Each author is paid a certain royalty rate on each book he or she authors, which potentiallyvaries for each book and for each author. An author receives a separate royalty check for each book heor she writes. Each check is identified by its check number, and we also keep track of the date andamount of each check.TasksDesign a SQL database using the above US superstore sales data set.1.Use Visual Paradigm to draw conceptual diagram2.Use Visual Paradigm todraw ERD
A Bank has many customers. Attribute for customer includes customer number, name, address (street, city, state and zip code), sex and date of birth. Customer can have multiple accounts. The bank does not allow join account (one account per customer). Type of account offer by the bank are Saving, Current and Fixed Deposit. Attribute for account are account no, account type, and account balance. Each of the account can only exist in a particular branch. Attribute for branch are branch no, branch name and address (street, city, state and zip code). Customer can open different account at different branch. Draw an ER diagram for the above situation. Identify the entity, attributes, primary key, relationship and multiplicity constraint in the ER diagram.
Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee. Status Vacation Time Earned Full TIme 10 Part Time 7 Contract 0 Employees Status Vacation TIme Earned John Contract Jane Part Time Al Full TIme
Create an ER Model for the following requirements: A car has a make, model and year. A registration has a county and date. A person has an address and an age. A car may be owned by a person. A car may be registered to an owner.
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.
The following shows a training company’s workshops, the number of days of each, and their registration fees. Workshop # of Days Registration FeeHandling Stress 3 $ 1,000Time Management 2 $ 800Supervision Skills 3 $ 1,200Negotiation 6 $ 1,500Interview Skills 1 $ 300The training company conducts its workplace in the six locations shown in the following table. The table also shows the lodging fees per day at each location. Location Lodging Fees per DayAustin $ 151Chicago $ 225Dallas $ 179Orlando $ 322Phoenix $ 175Raleigh $ 165When a customer registers for a workshop, he or she must pay the registration fee plus the lodging fees for the selected location. For example, here are the charges to attend the Supervision Skills workshop in Orlando. Registration: $1,200Lodging: $322 * 3 days = $966Total: $2,166Create an application that lets the user input a workshop and location from the lists. The application should display the workshop and lodging prices, calculate and display the registration…
The KCA library orders books from one or more book suppliers. Each order contains quantity of books required, mode of delivery and the order date. The detail captured about a book includes the ISBN number, the title, author and publisher of the book. Books may be borrowed by registered members, who are identified by a borrower number. The library also keeps members’ name, email address and phone number. A member may borrow a maximum of two (2) books on each occasion. A supplier delivers one or more books orders to the library. The supplier’s name, address and telephone contact is kept by library. Draw an ERD to model the data stored in the KCA library system.
Look up the average evaluation score earned by instructor Egan for the Emergency Care course: In cell E14, begin to enter a formula using the XLOOKUP Use the instructor name in cell E12 as the value to look up. Use a structured reference to the header row of the Evaluations table as the table to search. Return the value in the range E4:I4. I need help with the sttructured reference refered in #3
List the name of each employee. If the employee has a supervisor, then also list the name of the supervisor. Show the names of employees and supervisors by respectively renaming the attributes to Employee_Name and Supervisor_Name. Retrieve the names and salaries of all employees who do not work on a project with a name called 'ProductX'.
kindly explain the flow of data on the diagram.
Use the sample output below as a reference to compile a list of every purchase made by customers. The following criteria should be used to sort the results: code, invoice number and product description for each client All three INVOICE, LINE, and PRODUCT groups must be linked together to complete the integration.
Considering the un-normalized relational table PROJECT below: PROJECT (Project Title, EmpeName, ManagerName, Location, Hours Work, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.