Database Systems: Design, Implementation, & Management
13th Edition
ISBN: 9781337627900
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 5, Problem 3P
Explanation of Solution
Crow’s Foot ER diagram for Granite Sales:
The following data model shows the solution for the given question.
Explanation:
- In the above data model, “Employee” and “Department” is in a relation of one-to-many relationship, because one department may contain many employees. The primary key of “Department” entity is “Dep_No” and the “Employee” entity is “Emp_No”...
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A course instructor will assign grades from (A, B+, B, C+, C, D+, D, EJ. What is the minimum number
of grades that must be assigned in order to guarantee at least one of the grades has been assigned
10 times.
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
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.
Chapter 5 Solutions
Database Systems: Design, Implementation, & Management
Ch. 5 - Prob. 1RQCh. 5 - What kinds of data would you store in an entity...Ch. 5 - Prob. 3RQCh. 5 - What is a subtype discriminator? Give an example...Ch. 5 - Prob. 5RQCh. 5 - What is a disjoint subtype? Give an example.Ch. 5 - What is the difference between partial...Ch. 5 - Prob. 8RQCh. 5 - According to the data model, is it required that...Ch. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - When implementing a 1:1 relationship, where should...Ch. 5 - What is time-variant data, and how would you deal...Ch. 5 - Prob. 17RQCh. 5 - Prob. 1PCh. 5 - Prob. 2PCh. 5 - Prob. 3PCh. 5 - Prob. 4PCh. 5 - Prob. 5PCh. 5 - Prob. 6PCh. 5 - Prob. 7PCh. 5 - Prob. 8CCh. 5 - Prob. 9CCh. 5 - Prob. 10C
Knowledge Booster
Similar questions
- ManufacturerA manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components. Each component can be supplied by one or more suppliers. The following component information is kept: component ID, name, description, suppliers who supply them, and products in which they are used.Assumptions• A supplier can exist without providing components.• A component does not have to be associated with a supplier.• A component does not have to be associated with a product. Not all components are used in products.• A product cannot exist without components. Construct an ERD table to show how you would track this information.arrow_forwardCreate a use case sequence diagram using the information below. Buy Parts Customer/Store Employee Description: This use case describes car parts dealer purchasing. Successful Finish: client requests vehicle component 2. Store associate verifies availability 3. component is available and client pays cost 4. Customer receives part; stock adjusted. 1. Customer asks auto part 2. Store Associate checks part availability 3. Part is unavailable and customer chooses to order part or no part 4. Customer receives part and stock is updated (if alternate part ordered) or leaves without part. Alternative: Customer wants component. No post-condition No assumptionsarrow_forwardLuxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to theWashington, D.C. area. In recent years, LOST has grown quickly and is havingdifficulty keeping up with all of the various information needs of the company. Thecompany’s operations are as follows:LOST offers many different tours. For each tour, the tour name, approximatelength (in hours), and fee charged is needed. Guides are identified by anemployee ID, but the system should also record a guide’s name, home address,and date of hire. Guides take a test to be qualified to lead specific tours. It isimportant to know which guides are qualified to lead which tours and the datethat they completed the qualification test for each tour. A guide may be qualifiedto lead many different tours. A tour can have many different qualified guides.New guides may or may not be qualified to lead any tours, just as a new tour mayor may not have any qualified guides.Every tour must be designed to visit at least three…arrow_forward
- Draw an ERD for the following scenario: A department employs many employees, but each employee is employed by one department. Each employee has the following characteristics: emp_Num, emp_FName, empLName, empAdress. Each department has a code and a name. Some employees, known as “rovers,” are not assigned to any department. A division operates many departments, but each department is operated by one division. Each division has a code and a name. An employee may be assigned many projects, and a project may have many employees assigned to it. Each project has a code and a name. An assignment is characterized by a date and number of hours. A project must have at least one employee assigned to it. One of the employees manages each department, and each department is managed by only one employee. One of the employees runs each division, and each division is run by only one employee.arrow_forwardTask Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table. Through Java application, use SQL to insert (random but meaningful) data records in the above tables:1) Create two different departments (named: Marketing and Human Resources)2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3.3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.arrow_forwardDomain Model Class Diagram LAB 6: Academic Scenario With the following information given below, design a domain model class diagram. A university has only full-time and part-time instructors. The details of an instructor include name, address, email, and number. The students in the university can enroll in a seminar and the details to be stored for each student include name, student number, and email. Each seminar consists of seminar name and seminar code. Full-time instructors are responsible for taking the seminars. Each seminar can be taken by at least one and at most two instructors. Part-time instructors can teach courses as well as full-time instructors. Each course consists of a name and course code. Students can register for a maximum of five courses per semester. A course can either be a university elective or an area elective. The availability of an area elective course depends on the number of available students for that course. A student can either be a bachelor, master's,…arrow_forward
- Each department runs a number of courses. The university provides a set of modules used in different courses. Each course uses a number of modules but not every module is used. A course is assigned a unique course code and a module is identified by a unique module code. A module can be used in one course only, but can be studied by many students. In addition to the module code each module unique title, start date, end date, texts (books), and assessment scheme (i.e., coursework and exam marks percentages) are also stored. Each course is managed by a member of academic staff, and each module is coordinated by a member of academic staff also. The database should also store each course unique title, and duration (in years). A student can enroll in one course at a time. Once enrolled a student is assigned a unique matriculation number. To complete a course, each student must undertake and pass all the required modules in his/her course. This requires that the database store the…arrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).can I know how to answer question a and b ?arrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).what is the input,process,output and pseudocode or flowchart for this question?arrow_forward
- University AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... Figure B (a) analyze the given problem (identify input, process and output).(b) design the given problem (write a pseudocode or draw a flowchart).arrow_forwardCreate a Crow's Foot ERD for the following description: The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.arrow_forwardUniversity AAA has 150 staff which consists of an academic and a non-academic category. Each staff is given an option to select either a PENSION ON 56 YEARS scheme or a PENSION ON 60 YEARS scheme. Display the details of each staff information and the total number of academic staff and non-academic staff that have selected a PENSION ON 56 YEARS scheme and a PENSION ON 60 YEARS scheme. Staffs’ InformationName NoIC Age Category Scheme……. …… …….. …… …..……. …… …….. …… …..……. …… …….. …… …..Report of selected SchemeCategory AcademicPENSION 56 : ....PENSION 60 : ....Report of selected SchemeCategory Non-AcademicPENSION 56 : ....PENSION 60 : .... (a) identify input, process and output for above program.(b) write a pseudocode or draw a flowchart for above programarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education