Question: Write the Create table command for the schema with primary and foreign key constraints (3+2) Member(memb_no,name,age) Book(isbn,title,authors,publisher) Borrowed(memb_no,isbn,date) i. Find the title, authors and publishers

Write the Create table command for the schema with primary and foreign key constraints (3+2)

Member(memb_no,name,age)

Book(isbn,title,authors,publisher)

Borrowed(memb_no,isbn,date)

i. Find the title, authors and publishers of the book.

ii. Find the names of members who have borrowed all books published by "Mc-Graw-Hill"

Step by Step Solution

★★★★★

3.49 Rating (149 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

sql Create the Member table CREATE TABLE Member membno INT PRIMARY KEY name VARCHAR100 age INT Creat... View full answer

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!

Q:

A bank has written a call option on one stock and a put option on another stock. For the first option the stock price is 50, the strike price is 51, the volatility is 28% per annum, and the time to...

Q:

a) Find the set of solutions of each of the linear congruence: i. 8x = 12 (mod 28). ii. 7x = 1 (mod 9). b) Hashing Function is used to assign a memory location for the records in the computer (For...

Q:

Normalize the data in table 1 attached show the EER diagram for your final results For each of the following steps, include screen shots of your code and results Use SQL code to create the tables...

Q:

Q1: Q2: Q3: Q4: The following questions will all use the schema for a library database as follows. Books (isbn, title, author, genre, publisher) Members (id, name) Lending (isbn, id, checkout,...

Q:

Why is risk management important to an exhibition management company? To an exhibitor? title Author ISBN Publisher Publication Date Professional Meeting Management Professional Convention Management...

Q:

INFOAP2 Database Design Study Block Project The University Boole Library Database Modelling Project The University Boole Library has approximately 19,000, members, 200,000 book titles, and 500,000...

Q:

EMPLOYEE Ename Office Age LOAN Isbn Date BOOKS Title Authors Publisher Public 1 year elations is straightforward. Primary key attributes are underlined. TH is the primary key for BOOKS, and Eid and...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

Q:

Question Ara corporation whose sole shareholder is Abe. After considering the current year's come Abe wa bussis is stock of $120,000 and ACE has $200,000 in its accumulated en count. ACE distributes...

Q:

Q1. Your client is a manufacturer of women's clothing. The company manufacturers everything from shorts and t-shirts to professional and formal attire for women. The visualization titled "Number of...

Q:

Frank Rogers owns a small firm that manufactures "Rogers Sunglasses."Frank has been approached by REI about selling a seasonal sunglass design through their stores. Frank offers REI two purchasing...

Q:

Bias can be very difficult to overcome. For instance, social networks help people get jobs. While this benefits some, it means that it is harder for those outside the network. Why does this...

Q:

Name Mech HW-79 1. Consider the four block-and-spring(s) systems shown at right. Each block moves on a horizontal, frictionless table. The blocks all ha Case A springs are iden I have the same mass...

Q:

What basic/fundamental need must the CIFFA forwarder identify and take into account before offering a transport alternative? Question 3 options: Safety and security of the cargo Reasonable...

Q:

Three employees of the Horizon Distributing Company will receive annual pension payments from the company when they retire. The employees will receive their annual payments for as long as they live....

Q:

The pendulum consists of two rods: AB is pin supported at A and swings only in the y-z plane, whereas a bearing at B allows the attached rod BD to spin about rod AB. At a given instant, the rods have...

Q:

State the three integrity rules. Indicate the reasons for enforcing each rule.

Q:

A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Use your own experience to determine any constraints you...

Q:

What are the 12 rules against which you can measure OLAP systems?

Q:

Explain how anger can negatively affect a conflict situation.

Q:

List ways to effectively control your anger and express it in constructive ways.

Q:

Describe the steps one must take to forgive.