Consider the following schema: Works (empID: String, deptName: String, started Date: Date,endedDate: Date) Which of the following is one of the super keys? O A. (empID, deptName, endedDate) O B. (empID, startedDate, , endedDate) O C. (startedDate,,endedDate) O D. (deptName, startedDate, , endedDate)

Consider the following schema: Works (empID: String, deptName: String, started Date: Date,endedDate: Date) Which of the following is one of the super keys? O A. (empID, deptName, endedDate) O B. (empID, startedDate, , endedDate) O C. (startedDate,,endedDate) O D. (deptName, startedDate, , endedDate)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

1. Break the table down to 1NF, 2NF anf 3NF.
Create a MySQL stored procedure to validate an attempt to create a new submission. The stored procedure should have parameters for the user, the user’s password, the id of the problem, the programming language (as a varchar), and the source code. An output parameter returns the result of the submission, which is one of the strings that can return or “Bad Parameters”, which handles cases such as incorrect password for the user, or the attempt to submit using a language that the program does not support (e.g., Malbolge or Visual Basic). The stored procedure can simulate the program judging process: if there is no Bad Parameters error, then randomly choose between Accepted, Wrong Answer, Time Limit Exceeded, and Run Time Error with equal probability. The submission should gets recorded in the database.
Database cource: a. Display student name and department name using the above view. b. Write a plsql program using cursors to display contents of table Dept.
Database Schema: branch ( branch_name, branch_city, assets ) customer ( ID, customer_name, customer_street, customer_city ) loan ( loan_number, branch_name, amount ) borrower ( ID, loan_number ) account ( account_number, branch_name, balance ) depositor ( ID, account_number ) Write a (postgresql) "trigger function" and "create a trigger" to carry out the following action: On delete of an account, for each customer-owner of the account, check if the owner has any remaining accounts, and if she does not, delete her from the depositor relation.
A database that is used to store your family names, emails, photos and their phone numbers is considered as: [Select all correct answers] O None O Multimedia Database O Traditional Database O GIS system Consider the database schema below for hotels countries. A country have many hotels, and the same hotel chain (name) are available in different countries. Country (ID: integer, Name: String (unique) Hotel (CountrylD: Integer, HotelName: String, ManagerID: Integer) The same hotel can have two different managers? O No, violates key constraint. O No, violates referential integrity constraint. O No, violates entity Integrity constraint O No, violates domain constraints. O Yes.
102. In relational database schemas, the state constraints are also known as a. static constraints b. dynamic constraints c. implicit constraints d. explicit constraints
Study the relational schema: EMP(ID, Name, DeptID) DEPT(DeptID, DName, Loc) Which of the following join conditions will correctly join the two tables? a. Emp.Name = Dept.DName O b. Emp.ID = Dept.ID O c. Emp.DeptID = Dept.DeptID %3D d. Emp.ID = Dept.DeptID %3!
115. The types of template dependencies are a. constraint generating templates b. tuple generating templates c. schema generating templates d. both a and b