Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table 3. Cust_Code ISBN Date_Trans Qty Unit_Price CIOI 3504 15/09/20 3 27 C102 3646 20/10/20 3 28 C103 3625 26/10/20 2 34 30 C104 3568

image text in transcribed

Table 3. Cust_Code ISBN Date_Trans Qty Unit_Price CIOI 3504 15/09/20 3 27 C102 3646 20/10/20 3 28 C103 3625 26/10/20 2 34 30 C104 3568 28/10/20 5 CIOI 3646 28/10/20 2 19 3530 10/11/20 4 34 C102 C103 3568 14/12/20 2 26 C104 350 23/12/20 3 35 Table 3. Sale_Inv_No ISBN Cust_Code C101 Date_Trans Qty Unit Price 3 27 3504 15/09/20 C102 3646 20/10/20 3 28 C103 3625 26/10/20 2 34 C104 3568 28/10/20 5 30 C101 3646 28/10/20 2 19 C102 3530 10/11/20 4 34 C103 3568 14/12/20 2 26 C104 3504 23/12/20 3 35 b. Create the relationship between these three tables, enforce referential integrity.(5%) Take screenshot of this relationship window c. Create a Query (Full Name_<_query that lists the isbn title year of publication and quantity on hand all books published after number items in storage between take a screenshot this query window d. create d list details containing word but author is window. e. e bought by customer. result publisher id f. unit _price from min to max price entered user dialog box sort ascending order when entering g. g name phone email address customers who got at least two digits or telephone number. h. report has fullname g_report nguyen vanan transactions each customer group cust code includes qty footer pubid print total amount code. created table cust_code date_trans unit_price cioi c102 c103 c104 sale_inv_no c101 b. relationship these three tables enforce referential integrity. c. name_>

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Term Structure Models A Graduate Course

Authors: Damir Filipovic

2009th Edition

364226915X, 978-3642269158

More Books

Students also viewed these Finance questions

Question

16. Refer to Exercise 14. State in words the event F = C).

Answered: 1 week ago