Subject : database system Illustrate a instance of sales invoice and sales person subsequently determine degree, cardinality, candidate key(s), and alternate key(s) for each instance CarCar DealershipPK Car_IDSerial NumberMakeModel(0,1)(1,1)ColourSales InvoiceYearCar for Sale Y/NSalespersonPK Invoice_IDCustomerPK Salesperson_ID(1,")(1,1)Invoice Number(1,1)PK Customer_IDDateFK1 Car ID (Foreign)FK2 Customer ID (Foreign)FK3 Salesperson ID (Foreign)(0,")Last NameFirst Name(1,1)Last NameFirst NamePhone Number(0,")Address(1,1)CityState/ProvinceCountryPostal CodeService Ticket(0,*)PK Service_Ticket_IDMechanicService Ticket Number(1,1)FK1 Car ID (Foreign)FK2 Customer ID (Foreign)Date ReceivedPK Mechanic_IDLast NameFirst NameCommentsService(1,1)Date Returned to CustomerPK 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)(0,")Parts UsedPartsPK Parts_Used_ID(1,")(1,1) PK Parts_IDHoursCommentFK1 Part ID (Foreign)FK2 Service Ticket ID (Foreign)Number UsedPart NumberDescriptionPurchase PriceRatePriceRetail Price

In the car dealership diagram, it contains 10 entities that includes: Salesperson, Sales Invoice,…

Answered: Subject : database system Illustrate a…

Subject : database system Illustrate a instance of sales invoice and sales person subsequently determine degree, cardinality, candidate key(s), and alternate key(s) for each instance

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section8.2: Lookup Tables And The Iferror Function

Problem 4QC

See similar textbooks

Similar questions

INVOICES INVOICE LINE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 INVOICE NUM ITEM ID QUANTITY 14216 QUOTED PRICE 14216 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 11/18/2021 435 14224 KH81 4. $18.99 14231 14233 14237 11/18/2021 11/18/2021 125 14228 FS42 $124.99 435 14228 PF19 1. $74.99 11/19/2021 616 14231 UF39 2. S189.99 14233 KH81 $19.99 QB92 WB49 LP73 14233 $109.95 14233 $74.95 14237 $54.95 ТЕМ ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE Dog Feeding Station Fenthers Bird Cage (12x24x18) AD72 12 DOG B. $79.99 10 BRD B $79.99 CA75 Enclosed Cat Litter Station 15 CAT $39.99 Dog Toy Gift Set Fly Mask with FRars Folding Saddle Stand Aquarium (55 Gallon) DT12 27 DOG B $39.99 FM23 41 HOR $24.95 FS39 12 HOR $39.99 FS42 FSH A. $124.99 KHS1 LD14 Wild Bird Food (25 Ib) 24 BRD $19.99 Locking Small Dog Door 14 DOG $49.99 LP73 Lange Pot Carrier 23 DOG $59.99 Pump & Filter Kit Quilted Stable…
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…
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…
Jquery 09-- do
1. 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)
SQL code for the Object-Identity and Reference Types.
Product Order PID Description Quantity 300 Price Vendor OID Date 2012/5/23 2 CID Unique traders AT Cosmetics General traders Unique traders General traders Foodie Shop Shampoo 50 1 1 2 Soap 140 230 40 30 2012/5/24 3 Detergent 4 2016/4/23 4 Milk 14 33 3 2016/2/12 2016/1/10 4 Lemon Max 10 20 6 1 6. Chocolate 34 34 Invoice Customer OrderNo 1 ProductID Quantity CustomerID Name city 1 1 Ali Rawalpindi 1 3 1 Ahmad Islamabad 4 2 1 Umer Chakwal 2 6. 3 Каrim Islamabad 2 3 1 Shafig Islamabad 3 2 6. Waleed Rawat 4 Afzal Islamabad 4 3 4 1 Bilal Rawalpindi 4 4 Write SQL queries for the following statements (Use only Cartesian product and join) 1. Showname of customerand orderno who have placed any order and belong to "Islamabad". 2. Showname of customer and product description who placed order before 2016/2/23. 3. Show data of those customer who place two or more than two order in same day. 4. Showdata of those product that are purchased by those customer who neither belong 5. To"Rawat"nor…
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level
help me to answer the question below tutorsss
student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> credits
SQL Server supports a variety of character data types, including NVARCHAR, NVARCHAR, and NVARCHAR.
Table_rating table menu table_menu_type table_user menu_type_ID rating ID menu ID user_ID placed • type_name • description # menu_ID • remarks • data_recorded: date # customer ID • menu_name # price #menu_type ID • menu image ingredients #menu_status • full_name • contact • email address * username • password assigned represent table_payment payment_ID 4 order ID C# amount paid_by -payment_date # processed_by | assigned to table_customer customer_ID • Customer_first_name • customer_last_name • customer_middle_name • customer_email • customer_phone_number • customer_landline • profile_image • customer_usemame • customer password table_order_details I Jorder_details_ID include I l order_ID # menu_ID # amount # no of serving # total_amount table_site_info # account_status site_info_ID L • site_name • description • contact_info * address • last_update Huser_ID table_order part of placed by # customer_ID -order_date #total_amount Worder_status #processed_by pays orders Customers PK…