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): a. Each time an employee wants a vehicle a new assignment is made. b. An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle. c. A vehicle may have multiple assignments. d. 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. e. An assignment may have the status of Assigned, Out, or Returned. f. A vehicle may only be "Out" on one assignment and an employee may only have one assignment "Out". VEHICLE EMPLOYEE 1 7 STATUS 34 ASSIGNMENT 56 2 8 00 LOCATION

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): a. Each time an employee wants a vehicle a new assignment is made. b. An employee can have multiple assignments, but each assignment is for only one employee and only one vehicle. c. A vehicle may have multiple assignments. d. 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. e. An assignment may have the status of Assigned, Out, or Returned. f. A vehicle may only be "Out" on one assignment and an employee may only have one assignment "Out". VEHICLE EMPLOYEE 1 7 STATUS 34 ASSIGNMENT 56 2 8 00 LOCATION

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

7
What exactly are double constraints, and how do they work?
Question 20 Please fill in the blank correctly.
Transform ERD into Relation
What is the difference between disjoint constraints and overlapping constraints, and how are they used?
An attribute of a composite primary key has a candidate key. What is your response to this information?
Schema: Part(PartNo, PartName, VehicleType, UnitPrice, SalesPrice) Service(ServiceNo, PartNo, ServiceDate, CustomerNo, Qty) Constraints: i. Vehicle Type should be V1', V2', 'V3', 'V4', or 'V5' ii. UnitPrice and SalesPrice should be greater than zero iii. PartNo, FK in Service refers to PartNo, PK in Part Data: Part Service P1 V1 10 12 1 01-Jan-17 C1 P2 V2 100 110 3 01-Jan-17 C1 4 P3 V1 150 175 2 3 05-Feb-18 C2 10 P4 V3 200 250 3 1 15-May-18 Сз 9. P5 V2 75 90 1 03-Jun-19 C1 A. Write the following queries in SQL: i. List the Part Names which are not used to service the vehicle of any customer. ii. List the customer number who has got his vehicle serviced maximum number of times. iii. List the customer number whose vehicle service used all the parts of vehicle type V1. B. Write a PL/SQL program to find the total profit done in the sales of a given part number in the service of different customer vehicles. Raise an exception for invalid part number. 12345n
Bottom two please show how to do, i do not need to understand what I have marked out
40. Every aggregation relationship is an association O True False
You have an application domain that consists of Cities, Towns, and Neighborhoods. A City has a name, zip code, state, and a country. A Town has a name, zip code, state, and country. A Neighborhood has a name, coordinate, and population. Using a relational model, what are Students, Courses, and Sections called? Select one: a. Attributes b. Constraints c. Entities d. Relations
Given the following relation that stores details of employees and their projects: If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. 1.ProjectID ➡ EmployeeName 2.ProjectID ➡ EmployeeSalary 3.ProjectID , EmployeeName ➡ EmployeeSalary 4.EmployeeName ➡ EmployeeSalary 5.EmployeeSalary ➡ ProjectID 6.EmployeeSalary ➡ EmployeeName , ProjectID