Q1. Create these two relations, then insert the tuples. (Instructor relation: ID is PK, dept_name is FK, set name not null and unique, every tuple in salary must be greater than 35000 and less than 100000) (Department relation: dept_name is PK) Department deptлame building budget Biology Comp. Sci. Elec. Eng. Watson 90000 Taylor 100000 Тaylor 85000 Finance Painter 120000 History Painter 50000 Music Packard 80000 Physics Watson 70000 Instructor ID пате deptлame salary Comp. Sci. Finance 10101 Srinivasan 65000 12121 Wu 90000 15151 Mozart Music 40000 Physics History Physics Comp. Sci. History 22222 Einstein 95000 32343 El Said 60000 33456 Gold 87000 45565 Katz 75000 58583 Califieri 62000 76543 Singh Crick Finance 80000 76766 Biology Comp. Sci. Elec. Eng. 72000 83821 Brandt 92000 98345 Kim 80000

Q1. Create these two relations, then insert the tuples. (Instructor relation: ID is PK, dept_name is FK, set name not null and unique, every tuple in salary must be greater than 35000 and less than 100000) (Department relation: dept_name is PK) Department deptлame building budget Biology Comp. Sci. Elec. Eng. Watson 90000 Taylor 100000 Тaylor 85000 Finance Painter 120000 History Painter 50000 Music Packard 80000 Physics Watson 70000 Instructor ID пате deptлame salary Comp. Sci. Finance 10101 Srinivasan 65000 12121 Wu 90000 15151 Mozart Music 40000 Physics History Physics Comp. Sci. History 22222 Einstein 95000 32343 El Said 60000 33456 Gold 87000 45565 Katz 75000 58583 Califieri 62000 76543 Singh Crick Finance 80000 76766 Biology Comp. Sci. Elec. Eng. 72000 83821 Brandt 92000 98345 Kim 80000

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Q9
Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASE
Add the ends to the relations on the Crows Foot ERD for the business rules of the XYZ Company's motor pool (a motor pool typically is a group of vehicles that are temporary assigned to employees to drive for business purposes): Each time an employee wants a vehicle a new assignment is made. An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle. A vehicle may have multiple assignments. The XYZ location at the end if the assignment is stored in the assignment. It is assumed tht the assignment begins at the destination of that vehicles prior assignment. An assignment may have the status of Assigned, Out, or Returned. A vehicle may only be "Out" on one assignment and an employee may only have one assignment "Out".
A relation FarmVisit is defined below with attributes in the table headings. FarmVisit visitorID visitorName date farmID farmName t1 H001 John 1 Feb 2021 A10 Green Field t2 Н005 Ashley 1 Jan 2021 A10 Green Field t3 но05 Ashley 1 Feb 2021 A10 Green Field t4 H005 Ashley 15 Apr 2021 H02 Есо t5 Но06 Ashley 15 Apr 2021 A11 Green Field a) Write down examples of tuples (i.e., tl, t2) to show neither of the following is a functional dependency: (i) visitorID -> date (ii) date -> farmID b) Write down the functional dependency (FDs) using the above data, which can represent all possible data. The FDs should be non-trivial and the determinants of the FDs should contain minimal number of attributes required. c) Using the tuples given, can (visitorID, farmID) be the primary key of FarmVisit? Explain why. d) What the highest normal form by which the FarmVisit relation can be classified? Explain why.
convert it to relations that are normalization
Apply the normalization process to the Das Auto relation shown below to develop a set of normalized relations. Show the results of each of the steps in the normalization process. CarMake CarModel Year CarType LicensePlate State OwnerLastName OwnerFirstName OwnerPhone OwnerEmail Service Date Charge BMW 330i 2020 Sedan 20487963 MA Yee Lucy 205-304-6598 lucy.yee@gmail.com Oil Change 8/9/2020 $ 80.00 Mercedes-Benz C280 2006 Sedan 31598769 NH Koka Bardhyl 301-987-9354 bardhyl.koka@yahoo.com Brake Hose Replacement 5/9/2020 $ 550.00 Audi S5 2018 Convertible CH 06874 MA Jones Andy 547-963-5478 andy.jones@gmail.com Fuel Pump Replacement 5/9/2020 $ 423.00 Porsche Cayenne 2014 SUV LH 05879 NH Papa Katie 512-568-7849 katie.papa@aol.com Brake Pads 6/3/2020 $ 232.00
Each relationship is mapped into a relation? true or false
14. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. a. Rows b. Key c. Attribute d. Fields
q16
Please convert this EERD to RELATION. Thanks! Use arrow to identify the foreign key, not only box and tell where is the foreign key. Draw it in paper, thanks!!!