Easy MCQ please answer fast Question 7A relation is said to be in 1NF ifOthere are only a few multi-valued attributesO all attributes are the same type.Othere is no duplication of datathere are no multi-valued attributes in the relationQuestion 3How do you select all the records from a table named "Persons" where the "FirstName" "Peter"and the "LastName" is not "Jackson"?O SELECT * FROM Persons WHERE FirstName<>"Peter' AND LastName<>'Jackson'SELECT FirstName-Peter, LastName='Jackson' FROM PersonsSELECT * FROM Persons WHERE FirstName="Peter" AND LastName<> JacksonO SELECT * FROM Persons WHERE FirstName-Peter' AND LastName NOT 'Jackson'Question 10Given the following relation, it is not 3 NF becauseStudent (student id, name, year of study, address, course_id, course name)O it does not have composite keyO non-key attribute course_name is functionally dependent on course_id and not student_idO it does not have composite keyO it has more than 3 non-key attributes

Question 7: A relation is in first normal form (INF for short) if the domains of all its attributes…

Question 7 A relation is said to be in 1NF if Othere are only a few multi-valued attributes O all attributes are the same type Othere is no duplication of data there are no multi-valued attributes in the relation Question 3 How do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is not "Jackson"? O SELECT * FROM Persons WHERE FirstName< Peter AND LastName Jackson O SELECT * FROM Persons WHERE FirstName-Peter AND LastName NOT Jackson' Question 10 Given the following relation, it is not 3 NF because Student (student id, name, year of study, address, course_id, course name) O it does not have composite key O non-key attribute course name is functionally dependent course_id and not student id it does not have composite key it has more than 3 non-key attributes

Question 7 A relation is said to be in 1NF if Othere are only a few multi-valued attributes O all attributes are the same type Othere is no duplication of data there are no multi-valued attributes in the relation Question 3 How do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is not "Jackson"? O SELECT * FROM Persons WHERE FirstName< Peter AND LastName Jackson O SELECT * FROM Persons WHERE FirstName-Peter AND LastName NOT Jackson' Question 10 Given the following relation, it is not 3 NF because Student (student id, name, year of study, address, course_id, course name) O it does not have composite key O non-key attribute course name is functionally dependent course_id and not student id it does not have composite key it has more than 3 non-key attributes

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

Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the diagram below 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 these…
The properties of the relation object can be used to implement the master-detail functionality which most appropriate for your application. You can delete a master-detail relation by selecting it in the Object Navigator and choosing Navigator => Delete. Discuss the Deletion of Relations in detail.
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…
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 features do normalization procedures that use functional dependencies have?
Design the database as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy) Draw your corrected design as a logical ERD showing attributes and multiplicities (suggest you use IE Notation in Oracle Data Modeler). No need to include physical data types. Modify the sample data from step 1 in a new page to match this design
What happens if we don’t specify the WHERE clause in an SQL DELETE FROM statement? a) statement compilation causes a “Syntax error”, and the statement is not executed. b) all the tuples of the relaton are deleted. c) none of the tuples of the relation is deleted. d) all the tuples not satisfying the condition are deleted. e) none of the above. Which one(s) of the following is(are) procedural? a) Relational Algebra b) Relational Calculus c) Tuple Relational Calculus d) Domain Relational Calculus e) SQL f) (a) and (e) e) (b) and (e).
Design the database as a single relation called Movie. It should contain an ID, Title, Year Released, Genre (e.g., sci-fi, comedy, thriller, etc.), Rating (e.g., G, PG, R, etc.), Format (e.g., VHS, DVD, MP3, etc.), a free-form Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: 2009 Genre: Sci-Fi Rating: PG Format: DVD Director: J. J. Abrams Starring: Chris Pine (Capt. Kirk), Zachary Quinto (Mr. Spock) Zoe Saldana (Uhura), Karl Urban (Bones McCoy)
Sabir and Sons Company were doing very well before the COVID pandemic took over all the World. The employees usually had to make business tours all across the globe. Following is the Table schema of their tours made before COVID-19: Tour ( Tour_ID, Begin_Date, End_Date, Stayed_Countries, Used_Cards) You are required to create sample (mock-up/dummy) data records of the above relation. This way every student should have separate data. Then create the Functional Dependencies and normalize the relations step by step up to BCNF. (Hint: Neat and Clean Work with proper demonstration gets you good marks)
PLZ help with the following: IN SQL Let R (A, B, C) be a relation schema. What happens if we execute the following query? SELECT* FROM R WHERE A=D; Select one: a. We get an error. b. The query executes successfully but returns no tuples. c. The query returns all the tuples in R.
7.Using the Henry Books database,decrease the inventory of book code 6128 at branch 2 by one. You will insert 2 snips for this question: What construct did you use to decrease the inventory? Insert the snip of the construct used: Insert the snip of the inventory table. Be certain book code 6128 displays:
For the following Student table, find all the possible functional dependencies that arehe ld.Schema: Student (Regno, Name, DOB, Phone, Instructor_ID, Instructor_Name, Instructor_Office)Gender, Course_ID, Course_Na me ,Regno Name 14M01 Kumar 14M05 Mary 14M07 Ram 14M01 Kumar 14B01 Revathi 14M09 Steve 14B03 RamyaDOB 12-Jan-1996 10-Jun-1995 10-May-1996 12-Jan-1996 10-Dec-1995 23-Oct-1995 20-Jul-1996Phone 12345 12367 12898 12345 23456 34567 23456Gender CID M C1 F C1 M C1 M C3 F C3 M C4 F C4CNam