With the following Object Oriented Relational Database schema, select the attributes that a tuple in Teachers would have.     create type Person     (ID varchar(20) primary key,      name varchar(20),      address varchar(20))  ref from(ID); create table people of Person;     create table students     ( degree varchar (20))     inherits people ; create table teachers     ( salary integer )     inherits people

Design a relational database schema from the Car Sharing IS domain class diagram. Output should look like image number 2

Consider the following database scheme Employee (SSN, fname, lname, salary, deptno) Department (deptno, dname, total_salary) Where total salary is a derived attribute that represents the total salary of employees working in a specific department. Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.

We have the following functional dependency A -> B. The following is a well-formed database design. MYTABLE (TheKey, A, B, C) True False

Consider the following database scheme Employee (SSN, fname, lname, salary, deptno) Department (deptno, dname, total_salary) Where total salary is a derived attribute that represents the total salary of employees working in a specific department. Write a trigger to compute the total_salary in the event of inserting one or more new employee record(s) in the employee table.

In what situations might "materialized views" be used in a database model?

Consider a database with the following schema: Person ( name, age, gender )        name is a keyFrequents ( name, pizzeria )         (name, pizzeria) is a keyEats ( name, pizza )                       (name, pizza) is a keyServes ( pizzeria, pizza, price )      (pizzeria, pizza) is a key Write relational algebra/SQL expressions for the following:a. Find the names of all females who eat both mushroom and pepperoni pizza.b. For each person, find all pizzas the person eats that are not served by any pizzeria the personfrequents. Return all such person (name) / pizza pairs.c. Find all pizzerias that are frequented by only females or only males.

Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register…

Consider the following database instance. Table name: Students  Primary key: sid Sid sname 7 Ricky 2 Ellen 6 MaryLou 4 Ellen   Table name: Courses  Primary key: cid cid cname 1 ICS 2 Finance   Table name: Register Primary key: sid,cid Foreign key: sid references Students(sid) Foreign key: cid references Courses(cid) sid cid 7 2 2 2 7 1 4 1   5.1) For each of the following statements, show whether the statement is correctly executed or not (assume that the statements are executed in order, which means that if a statement is correctly executed, its effect is reflected in the following statement). If you say the statement is not executed, explain why. INSERT INTO Students VALUES (3, ‘Ellen’);     INSERT INTO Students VALUES (6, ‘Ellen’);     INSERT INTO Register VALUES (1, 2);     INSERT INTO Courses VALUES (5, ‘Systems’);     INSERT INTO Register VALUES (6, 5);     INSERT INTO Register…

1) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table.If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.