When creating DB tables that contain foreign key references to other tables, you must: A first create the table in which the primary key is a foreign key B first create the table in which the foreign key is a primary key first remove all integrity constraints D) it does not matter, you are free to create any table first

When creating DB tables that contain foreign key references to other tables, you must: A first create the table in which the primary key is a foreign key B first create the table in which the foreign key is a primary key first remove all integrity constraints D) it does not matter, you are free to create any table first

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

Create a table named "student" with the following columns/fields: 1. id - integer not null primary key and auto increment 2. name - string with max of 200 characters not null 3. birthdate - date allows null Enter your answer 2. Create a database named "enrollment" Enter your answer 3. Get all the columns/fields of the "student" table. Enter your answer 4. Update the name of the student to "John Doe" where its id is 10. Enter your answer 5. Modify the "student" table by adding "address" column/field as string and allows null. Enter your answer 6. Delete all the records in "student" table. Enter your answer 7. Delete a record in "student" table where its id is 1. Enter your answer 8. Get only the "name" and "birthdate" of the "student" table where its "name" starts with "Jo" Enter your answer
14. How many records are created when you apply a Cartesian join (Cross join) to the invoice and invoice items table? 1. The following diagram is a depiction of what type of join? a. Inner Join b. Full outer join C. Left join d. Right join 16. Select which of the following statements are true regarding inner joins. (Select all that apply) a. There is no limit to the number of table you can join with an inner join. b. Performance will most likely worsen with the more joins you make Inner joins retrieve all matching and nonmatching rows from a table d. Inner joins are one of the most popular types of joins use 17. Which of the following is true regarding Aliases? (Select all that apply.) a. Aliases are often used to make column names more readable b. SQL aliases are used to give a table, or a column in a table, a temporary name. An alias only exists for the duration of the query. 18. What is wrong with the following query? SELECT Customers.CustomerName, Orders.OrderID FROM LEFT JOIN ON…
Create a SQL statement in MariaDB with the following columns and their aliases from the Employees table. Aliases should be created as seen including case sensitive. (A full statement is required, but doesnt need to be run with an output) Screenshot the code ONLY and attach. last_name - Name street_address - Local Address phone_number - Phone #
I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT Edit Question I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT CLASS. How would you add PK to a table, without dropping it, for which no PK was declared with Create.
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
Define the term referential integrity constraint. Give an example of a referential integrity constraint for the tables you created for question 1.8.
Write a SQL script that performs the following. Creates an updatable view based on the employee table. The view must contain the following features Rename all of the columns Display all "manager" records Insert 5 new records into the base table (using the view) Display all the view records using the base table (to verify that the view performed the inserts)
When a table is in 3NF then which of the following options is CORRECT? The table should be in 1NF and doesn't have any partial dependencies The table should be in 2NF and doesn't have any transitive dependencies The table should be in 2NF and have transitive dependencies The table should be in 1NF and doesn't have any transitive dependencie
JANUARY DATA MANAGEMENT SHORTAND NOTATION FOR RELATIONAL SQL TABLES Notation Underlined Example Meaning The attribute(s) is (are) a primary key The attribute(s) is (are) a foreign key referencing relation R CREATE TABLE R A or A, B A cany SQL type>, B cany SQL type>, C cany SQL type>, D cany SQL type>, E cany SQL type>, A or A", B* Superscript name of relation PRIMARY KEY(A), As an example, the schema FOREIGN KEY (E) REFERENCES S(F) ): R(A, B, C, D, E') S(E, G, H) CREATE TABLE S F , G cany SQL type>, H cany SQL type>, PRIMARY KEY(F)) corresponds to the following SQL tables: EXERCISE Consider the following relational schema, representing five relations describing shopping transactions and information about credit cards generating them [the used notation is explained above]. SHOPPINGTRANSACTION (Transld, Date, Amount, Currency, ExchangeRate, CardNbrREDITCARD, StoreldSTORE) CREDITCARD (CardNbr, CardTypeCARDTYPE, CardowneroWNER, ExpDate, Limit) OWNER (Ownerld, Name, Surname, BirthDate,…
How to create tables, sequences, and indexes Exercises Write a script that adds an index to the order_date column in the Orders table in the mgs schema. Write a script that implements the following design: In the Downloads table, the user_id and product_id columns are the foreign keys. Create these tables in the ex schema. Create the sequences for the user_id, download_id, and product_id columns. Include a PL/SQL script to drop the table or sequence if it already exists. Include any indexes that you think are necessary. Write a script that adds rows to the database that you created in exercise 2. Add two rows to the Users and Products tables. Add three rows to the Downloads table: one row for user 1 and product 2; one row for user 2 and product 1; and one row for user 2 and product 2. Use the SYSDATE function to insert the current date into the download_date column. Use the sequences created in the previous exercise to get the values for the user_id, download_id, and product_id…
Alternate keys: Identify at least five keys (not already listed as PK or FK) needed by end users. These indexes would be considered Alternate or Secondary keys and are mostly used for queries and quick reporting. They may contain multiple columns. Books Authors Bookstore Members Sales transaction table Inventory table