14/12/2016 Student name ID number: Instructor: Dr. Samar Mouakket Mark- 10 You a

Question

14/12/2016 Student name ID number: Instructor: Dr. Samar Mouakket Mark- 10 You are asked to use Oracle SQL developer to create a database containing information about publishers and books. A. Create the following tables. Set the relationship between the two tables. Notice that each table name publisher publisher publishes many books. A book belongs to one publisher. Give the name of each table as the following: Field Name P no Pri Data Type text text text Field Size ke yes P name P country 15 15 book 3 Primary key yes Field Size Field Name B id B title Data Type text text number text 15 B price P no Create fable boox 3

Explanation / Answer

Solution:

Note: A is solved completely, please repost others.

A)

CREATE TABLE publisher(
P_no varchar(5),
P_name varchar(15),
P-coutnry varchar(15),
Country varchar(20),
    PRIMARY KEY (P_no),
  
);

CREATE TABLE book(
    B_id varchar(5),
B_title varchar(15),

B_price int (5),
P_no varchar(5)
    PRIMARY KEY (B_id ),
    CONSTRAINT FK_P_no FOREIGN KEY (P_no )
    REFERENCES publisher(P_no)

);

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.