Question: Do Problems 4 and 5 using Microsoft Access. 4. (14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a

Do Problems 4 and 5 using Microsoft Access.

4. (14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a SQL statement ...

Do Problems 4 and 5 using Microsoft Access. 4. (14 points) Problem

6-34, p.283, where the beginning words Write a database description means Write

This problem requires you to create a database with six tables based on Figure 6-11 on p.283 (see the paragraph before this problem). The 6 tables are linked as: FACULTY-QAULIFIED-COURSE-SECTION-REGISTRATION-STUDENT

Note that CourseID in the SECTION table should be a foreign key and thus dash-underlined in the table.

Turn in the SQL commands and the Relationship chart (press Alt + Print Screen key combination to copy-paste the chart into your Word file).

5. (8 points) From the PVF database find all orders placed by customers located in NJ and all orders that requested Product #8. Write a SQL UNION statement such that only one column, with heading OrderID, appears in the results. Turn in both the SQL commands and the Microsoft Access output results.

StudentID (integer, primary key.) StudentName (25 characters) FacultyID (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key) CourseName (15 characters) DateQualified (date) SectionNo (integer, primary key) Semester (7 characters) StudentID (integer, primary key.) StudentName (25 characters) FacultyID (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key) CourseName (15 characters) DateQualified (date) SectionNo (integer, primary key) Semester (7 characters)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Problems (60 points): 1. Transform each of the following ER or EER diagrams to a relational schema that shows referential integrity constraints and functional dependencies [see the Mapping Example...

(14 points) Problem 6-34, p.283, where the beginning words Write a database description means Write a SQL statement ... This problem requires you to create a database with six tables based on Figure...

Assignment 4 SQL Total points: 50 All problems are worth 5 points unless otherwise specified For each problem, submit your SQL statements and a screen shot of the SQL results in a single Word...

THIS IS A COMPANY I AM WORKING ON FOR BUSINESS POLICIES AND NEED HELP GETTING STARTED ESPECIALLY WITH THE EXCEL SPREADSHEET PART!!! THANK YOU!!! TAKE YOUR TIME IF YOU MUST I WANT TO BE ABLE TO...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Uploaded our Context Diagram, Was hoping someone could check for the validity of it according to the assignment. Bank Merc hand i Consignor se/ G oods Fees Cont racts Unso ld M ercha ndise / goo ds...

1. Convert the table in page 6 of the report into a chart (graph) and place it under the table with the chart and add proper caption to it. 2. All figures and tables must be numbered appropriately...

A statistician was testing the following set of hypotheses: H 0: p = 0.86 versus H a: p 0.86. Using a random sample of size 178, he found z = 1.58. What is the p -value associated with this test? a....

Explain the balancing of V-Engine.

Select the best answer from the choices below. Gifts received are excluded from taxable income. Inheritances received usually are excluded from taxable income. Both of the above are excluded...

1 out of 1 5 A key difference between amateur and professional investors is: Amateur investors rely on hot trading tips Professional Portfolio Managers invest in various asset classes Professional...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Question What is the tax credit for employer-provided child care facilities?

Question Can an employer recover excess assets in a VEBA when it terminates after paying out all benefits due to participants?

Question How is a term loan to an executive treated for tax purposes?