Considering the following ERD, which tables and fields (i.e., columns) you don't need to access in order to determine which book titles have been purchased by a customer and when the order shipped? CUSTOMERS Customers Lastname Firstname Emall Address City State Zip Referred Region ORDERS Orders Customere Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order Items ISBN Quantity Paideach a) Books: ISBN, Title BOOKS ISON Title Pubdate PublD Cost Retall Discount Category PROMOTION Gats Minretail Maxretall b) Orderltem: Order#, ISBN BOOKAUTHOR AUTHOR AuthorD d) None of the above is true ISON AuthorlD PUBLISHER PublD Name Contact Phone c) Orders: Order#, Customer#, Shipdate Lname Fname answer with proper explanation, explanation all options why correct ans why remain incorrect

Considering the following ERD, which tables and fields (i.e., columns) you don't need to access in order to determine which book titles have been purchased by a customer and when the order shipped? CUSTOMERS Customers Lastname Firstname Emall Address City State Zip Referred Region ORDERS Orders Customere Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order Items ISBN Quantity Paideach a) Books: ISBN, Title BOOKS ISON Title Pubdate PublD Cost Retall Discount Category PROMOTION Gats Minretail Maxretall b) Orderltem: Order#, ISBN BOOKAUTHOR AUTHOR AuthorD d) None of the above is true ISON AuthorlD PUBLISHER PublD Name Contact Phone c) Orders: Order#, Customer#, Shipdate Lname Fname answer with proper explanation, explanation all options why correct ans why remain incorrect

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

herpever applicable 2. Title field in Instructor table should allow only Mr., Ms., Mrs., Dr., Prof. as values apply check constraints
You are required to create the following tables in a database named SICKLEAVE:EMPLOYEESEMPLOYEE_ID VARCHAR(5) NOT NULL PRIMARY KEYEMPLOYEE_NAME VARCHAR(30) NOT NULLEMPLOYEE_SURNAME VARCHAR(30) NOT NULLDATE_OF_BIRTH DATE NOT NULLDOCTORSDOCTOR_ID VARCHAR(5) NOT NULL PRIMARY KEYDOCTOR_NAME VARCHAR(30) NOT NULLEMPLOYEE_SICKLEAVEEMPLOYEE_ID VARCHAR(5) NOT NULL PRIMARY KEYFOREIGN KEY REFERENCESEMPLOYEES(EMPLOYEE_ID)START_DATE DATE NOT NULL PRIMARY KEYDOCTOR_ID VARCHAR(5) NOT NULLNUMBER_OF_DAYS SMALLINT NOT NULL(20)Q.1.2 Populate the tables created in Q.1.1 with the following data:EMPLOYEESEMPLOYEE_ ID EMPLOYEE_NAME EMPLOYEE_SURNAMEDATE_OF_BIRTHI0001 Dominique Woolridge 1993-04-19I0002 Nico Baird 1991-11-19I0003 Derek Moore 1992-06-24I0004 Neo Petlele 1993-12-29I0005 Andrew Crouch 1994-01-30DOCTORS(10)Question 2 (Marks: 20)Q.2.1 Write a query that will display doctors' names that have not issued any doctor’scertificates to employees yet.Sample Results:DOCTOR_NAMEJulia Robbins(5)DOCTOR_ID…
Create the table that results from EMPLOYEE PRODUCT DEPT I am unsure of what to do here. I f the column DEPTNAME is in both tables do I put the column twice? Please explain what to do in this case and provide the result.
View 4 Seneca Courses Inc. Customer Forms All customer information for SCI is maintained on file forms. The following are sample customer information forms: CUST_ID 78 CUST _ID 54 NAME YORK UNIVERSITY NAME SENECA COLLEGE LOCATION NORTH YORK LOCATION NORTH YORK SALES_REP ANDRE MARTIN SALES_REP PARVEZ RAI CUST _ID 74 CUST _ID 43 NAME RYERSON NAME INDIGO BOOKS LOCATION TORONTO LOCATION TORONTO SALES_REP PARVEZ RAI SALES_REP ANDRE MARTIN Business Rules: NAME must always be different for each customer. SALES_REP must always have a value. SALES_REP must be an existing employee. A customer only has one sales rep, but the sales_rep may have more than one customer. Normalize the above user view. Document all steps including UNF, 1NF, Dependencies, 2NF, and 3NF and explain or list the…
In SQL write a query to remove a table and it's schema from the database. Table: Player(PID, Name, Age, Gender, Address, Contact)
what more ideas can be added here about errand assistance service application
Normalise the data : Table: Administrator Field Name Data Field Constraints Description size type varchar Admin ID 15 Primary Key Contains the Admin id Admin char 50 Not null Contains the Name Admin name Not null Contains email Email varchar 20 the Address char 10 Not null Contains the address Phone int 8 Not null Contains the Number phone number Table: Product Field Name Data type Field size Constraints Description Product ID varchar 20 Primary Key Contains the product id Product Name char 25 Not null Contains product name Category char 13 Not null Contains the category CustomerlD varchar 15 Foreign key Contains the customer id
define view named itemorder. using sql write the view definition of itemorde
Show the list of courses numbers that are taken at least once by students. The course should appear once even if the course is taken multiple times.
SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60; Q2: By Parent HeightCreate a table by_parent_height that has a column of the names of all dogs that have a parent,ordered by the height…
JUST THE ONE IN RED PLEASE. THANK YOU SIR
Assume that the Authors table is already built in the database with the following specifications: Authors: Column Name Data Type constrains Authors ID Author Name Varchar2(10) |Varchar2(30) Primary key Unique You Need to Create the Books table with the following specifications Column Name Data Type Constrains ISBN Book Title Book Price Author id Number (10) Varchar2(40) Number (4,2) Varchar2(10) Primary key Not Null referencing the Author_ID in the Author Table Complete the create statement by drag and drop the correct word: Create Table lblank (ISBN Number (10) plank, Book Title Varchar2blank ) Not Null, Book Price Number(4, 2), Auther IR blank (10) references Jolank (blank ); Author ID Books Number||Authors Not Nul Varchar2| Primary Key 40 h (United States)