Type ISBN eBook RelationName2 (AttrName1) Primary key {AttrName1) Price Book N Order Hardcopy Date Quantity RelationName1 (AttrName1, AttrName2) Primary key {AttrName1} Foreign key {AttrName2} references RelationName2 (AttrName1) M CoverStyle Customer Id Date Name Has Convert the following E-R diagram to a collection of relations. Determine all the primary and foreign keys. Use the following format to answer the question: Payment No

The table STUDENT has the attributes STUDENT_ID, NAME, SCHOOL_ID, and ADDR. The table SCHOOL has the attributes SCHOOL_ID, NAME, and STATE_CODE. Assume that there is a 1:N relation between SCHOOL and STUDENT. Which of the following creates a table that shows the STUDENT attributes and the corresponding SCHOOL attributes?   a. SELECT * SCHOOL_ID FROM STUDENT JOIN SCHOOL   b. SELECT * SCHOOL_ID FROM STUDENT JOIN SCHOOL USING(SCHOOL_ID)   c. SELECT * SCHOOL_ID FROM STUDENT NATURAL JOIN SCHOOL   d. SELECT * SCHOOL_ID FROM STUDENT, SCHOOL WHERE SCHOOL_ID = SCHOOL_ID

Please help with the folllowing: Consider the following declaration of a relation schema     CREATE TABLE R   ( A int PRIMARY KEY,    B int not null,    C char (1) );  Then execution of which of the following queries will fail?  QI:  Insert INTO R (B, C) Values (353, 'B');  Q2: Insert INTO R (A, C) Values (111, ‘A’);  Q3: Insert INTO R (A, B) Values (222, 335);      Select one: a. Both QI and Q2  b. QI only  c. Both QI and Q3  d. Q2 only

Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…