Subject = database systemPlease help with the problem in the picture below CarCar DealershipPK Car IDSerial NumberMakeModel| (0,1)(1,1)ColourSales InvoiceYearCar for Sale Y/NSalespersonPK Invoice_IDCustomerPK Salesperson_ID(1,*)(1,1)Invoice NumberDateFK1 Car ID (Foreign)FK2 Customer ID (Foreign)FK3 Salesperson ID (Foreign)(1,1)(0,")PK Customer_IDLast NameFirst Name(1,1)Last NameFirst NamePhone Number(0,")Address(1,1)CityState/ProvinceService Ticket(0,")PK Service_Ticket_IDCountryPostal CodeMechanicService Ticket NumberPK Mechanic_ID(1,1)FK1 Car ID (Foreign)FK2 Customer ID (Foreign)Last NameFirst NameDate ReceivedCommentsDate Returned to CustomerService(1,1)PK Service ID(1,1)(1,*)Service Name| (0,")(1,1)Service MechanicHourly RatePK ServiceMechanic_ID(1,)FK2 Service Ticket ID (Foreign)FK3 Service ID (Foreign)FK1 Mechanic ID (Foreign)HoursComment(0,")Parts UsedPartsPK Parts_Used_ID|(1,")(1,1) PK Parts_IDFK1 Part ID (Foreign)FK2 Service Ticket ID (Foreign)Part NumberDescriptionPurchase PriceRetail PriceRateNumber UsedPriceDesign one ANSI-SPARC Three-Level Architecture (Externallevel, Conceptuallevel) for at least two External view

Answered: Image /qna-images/answer/b2af1fcc-6aef-4417-a8ca-6b70ee462d12.jpg

Car Car Dealership PK Car ID Serial Number Make Model Colour Year Car for Sale Y/N (0,1) (1,1) Sales Invoice Salesperson PK Invoice_ID (1,") (1,1) PK Salesperson ID (1,1) Customer Invoice Number Date FK1 Car ID (Foreign) FK2 Customer ID (Foreign) FK3 Salesperson ID (Foreign) (0,") PK Customer ID Last Name First Name (1,1) Last Name First Name Phone Number Address (0,") (1,1) City State/Province Service Ticket (0,") PK Service_Ticket_ID Country Postal Code Mechanic Service Ticket Number (1,1) FK1 Car ID (Foreign) PK Mechanic_ID FK2 Customer ID (Foreign) Last Name First Name Date Received Comments Date Returned to Customer ↑(1,1) Service PK Service_ID (1,1) (1,*) Service Name Hourly Rate (0,") (1,1) Service Mechanic PK ServiceMechanic_ID (1,") FK2 Service Ticket ID (Foreign) FK3 Service ID (Foreign) FK1 Mechanic ID (Foreign) (0,") Parts Used Parts PK Parts_Used_ID |(1,") (1,1) PK Parts_ID Hours Comment Rate FK1 Part ID (Foreign) FK2 Service Ticket ID (Foreign) Number Used Price Part Number Description Purchase Price Retail Price Design one ANSI-SPARC Three-Level Architecture (External level, Conceptual level) for at least two External view

Car Car Dealership PK Car ID Serial Number Make Model Colour Year Car for Sale Y/N (0,1) (1,1) Sales Invoice Salesperson PK Invoice_ID (1,") (1,1) PK Salesperson ID (1,1) Customer Invoice Number Date FK1 Car ID (Foreign) FK2 Customer ID (Foreign) FK3 Salesperson ID (Foreign) (0,") PK Customer ID Last Name First Name (1,1) Last Name First Name Phone Number Address (0,") (1,1) City State/Province Service Ticket (0,") PK Service_Ticket_ID Country Postal Code Mechanic Service Ticket Number (1,1) FK1 Car ID (Foreign) PK Mechanic_ID FK2 Customer ID (Foreign) Last Name First Name Date Received Comments Date Returned to Customer ↑(1,1) Service PK Service_ID (1,1) (1,*) Service Name Hourly Rate (0,") (1,1) Service Mechanic PK ServiceMechanic_ID (1,") FK2 Service Ticket ID (Foreign) FK3 Service ID (Foreign) FK1 Mechanic ID (Foreign) (0,") Parts Used Parts PK Parts_Used_ID |(1,") (1,1) PK Parts_ID Hours Comment Rate FK1 Part ID (Foreign) FK2 Service Ticket ID (Foreign) Number Used Price Part Number Description Purchase Price Retail Price Design one ANSI-SPARC Three-Level Architecture (External level, Conceptual level) for at least two External view

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

What are homonyms and synonyms, and why should you avoid using them while creating databases?
Explain the role of foreign keys in maintaining referential integrity in a normalized database.
The select operation in a relational database allows you to limit the number of columns in a table that satisfy your criteria.Is that the correct or incorrect answer?
Topic: Database Design Provide an example of a 3 table OUTER join. Explain how it works and what the order of of the joins is.
Why is it so important to modify the structure of the database?
Topic: Database Design What are some concerns about using a date (or date time) as a primary key?
While working with a relational database, a select operation may be used to prune unnecessary columns from a table, making it more manageable.Could it be real or false?
When dealing with missing field values in a database, what are the three actions to take?
List out various user authorization to modify the database Schema
Explain the many types of indexes and their basic syntax in database programming.
Join two relation in DBMS
List the database's various relationships.