Benefits benefit_name {plan_options) category cost start_date end_date staff_id Enroll name salary manager Staff employee Manages

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…

What are three signals that a surrogate key should be generated for the primary key of a relation instead of using the main key?

Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course: STUDENT(SSN. Name, Major, Bdate). COURSE(Coursel, Cname, Dept) ENROLL(SSN, Course#, Quarter, Grade) BOOK ADOPTION(Course#. Quarter, Book_ISBN) TEXT(Book_ISBN, Book_Title, Publisher, Author) Draw a relational schema diagram specifying the foreign keys for this schema.

The conditions under which the database designer should employ supertype and subtype connections are outlined.

The dependency diagram indicates that authors are paid royalty for each book they write for a publisher.The amount of royalty can vary by author,by book ,and by edition of the book. a.Based on the dependency diagram,create a database whose tables are atleast in 2NF showing the dependency diagram for each table. b.Create a database whose tables are atleast in 3NF,showing the dependency diagram for each table.

create a table for the class entity in an ER diagram of a school system. Show the composite key in class table. Fill the table with 4 records. At what level in the database architecture we create tables ?

conver er model to relation model please draw the answer as digram

Subject:Database