Empl Id | Name | Address | SSN | Job Id | Job Title | Skill Cod | Dept | Start Date | Term Date |
25X15 | Joe E. Baker | 33 Nowhere St | 111223333 | F5 | Floor manager | FM3 | Sales | 9-1-2009 | 9-30-2010 |
25X15 | Joe E. Baker | 33 Nowhere St | 111223333 | D7 | Dept. head | K2 | Sales | 10-1-2010 | * |
34Y70 | Cheryl H. Clark | 563 Downtown Ave. | 999009999 | F5 | Floor manager | FM3 | Sales | 10-1-2009 | * |
23Y34 | G. Jerry Smith | 1555 Circle Dr. | 111005555 | S25X | Secretary | T5 | Personnel | 3-1-1999 | 4-30-2010 |
23Y34 | G. Jerry Smith | 1555 Circle Dr. | 111005555 | S26Z | Secretary | T6 | Accounting | 5-1-2010 | * |
• | • | • | • | • | • | • | • | • | • |
• | • | • | • | • | • | • | • | • | • |
• | • | • | • | • | • | • | • | • | • |
Figure 9.4
21. Design a relational
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Computer Science: An Overview (12th Edition)
Additional Engineering Textbook Solutions
Starting Out with C++: Early Objects (9th Edition)
Starting Out with Python (4th Edition)
Differential Equations: Computing and Modeling (5th Edition), Edwards, Penney & Calvis
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
Modern Database Management (12th Edition)
- Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.arrow_forwardSQL QUESTIONSarrow_forwardDESPATCH_LIST Order no Order Cus_name Dave E GONES 6023 6023 6028 6152 6152 date 28 Feb 28 Feb 02 Mar 04 Mar Dave E GONES Nick F JENS CHENG Chui 04 Mar CHENG Chui Order amount $1,248 $1,248 $1,290 $999 $999 Prod no EH06 DL21 EH06 SM17 SP38 Description Electric heater Desk lamp Electric heater Quantity Depot no Location 3 • Depot no determines Location (Order_no, Prod_no) determines Quantity, Depot_no 3 6 Sewing machine 1 Sewing pack 10 where, (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description N24 K10 НОЗ N24 K10 Shatin Hunghom Aberdeen Shatin Hunghom Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.arrow_forward
- Suppliers * SupplierlD Products Order Details Orders Customers * CustomerID V ProductID 9 OrderlD V ProductID * OrderlD CompanyName ProductName 00 CustomeriD EmployeelD OrderDate CompanyName ContactName SupplierID CategoryID QuantityPerUnit UnitPrice UnitPrice ContactName ContactTitle Quantity ContactTitle Address Discount RequiredDate Address City Region City ShippedDate ShipVia Unitsinstock 00 Region PostalCode UnitsOnOrder PostalCode Freight ShipName ShipAddress ShipCity ShipRegion ShipPostalCode ShipCountry Employees V EmployeelD Country Reorderlevel Country Phone Discontinued Phone Fax LastName Fax HomePage FirstName Title TitleOfCourtesy Shippers V ShipperID Birthdate Categories * CategorylD HireDate CompanyName Address Phone CategoryName Description City Region Picture PostalCode Country HomePhone Extension Photo Notes Reportsto Figure 2. The relationship diagram of the NorthWind database. a. Use the ERDPlus tool to design a STAR schema of the data warehouse containing one fact…arrow_forwardanswer the followingarrow_forwardIdentify for each table, the followings: Foreign keys Candidate keys Primary key Alternate keysarrow_forward
- Given the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees…arrow_forwardUSE MICROSOFT SQL SERVERarrow_forwardQ4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.arrow_forward
- student Relation Student_ID Student_Name Dept_Name 0000 AAAAA Computer Science 1111 BBBBB Computer Science 2222 CCCCC Business Administration 3333 DDDDD Education 4444 EEEEE Physics 5555 FFFFF History Student_Courses Relation Student_ID Course_ID Section Year Grade 0000 CS 2203 2 2020 A 0000 CS 1101 1 2019 A 1111 CS 1101 5 2019 B 1111 CS 1102 1 2019 B 1111 CS 2204 1 2020 A 1111 CS 2401 1 2020 A 2222 BUS 1101 3 2019 C 2222 BUS 2201 1 2020 B 2222 BUS 3302 1 2020 B 3333 EDUC 5010 1 2019 A 3333 EDUC 5210 1 2020 B 4444 PHY 1101 4 2019 A 4444 PHY 2202 1 2020 C 4444 PHY 3304 1 2020 A Considering Student and Student_Courses relations shown above, discuss when Union, Inner Join, Left Outer Join, Right Outer Join, and Full Outer Join should be used and provide examples using the above relations. I AM GETTING USED TO MYSQL WORKBENCH. (Kindly take me through the path)arrow_forward1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)arrow_forwardDESPATCH_LIST Order no Order Cus_name Order Prod no Description Quantity Depot_no Location date amount 6023 28 Feb Dave E GONES $1,248 EHO6 Electric heater 3 N24 Shatin Dave E GONES $1,248 Desk lamp 6023 28 Feb DL21 K10 Hunghom 6028 02 Mar Nick FJENS $1,290 EHO6 Electric hester ноз Aberdeen 04 Mar CHENG Chui Sewing machine 1 6132 $999 SM17 N24 Shatin CHENG Chui Sewing pack 6132 04 Mar $999 SP38 10 K10 Hunghom where, (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description Depot_no determines Location • (Order_no, Prod_no) determines Quantity, Depot_no Q3. Using the DESPATCH LIST table above, identify one example each for insertion, deletion and modification anomalies.arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage