Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 1, Problem 10MC
Which of the following has no partial dependencies but can contain transitive dependencies?
- a. unnormalized data
- b. 1NF
- c. 2NF
- d. 3NF
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
You have a list of all your contacts details that you would like to store in a database. Your goal is that when a record is inserted in contacts
table, you also want this record to be stored (inserted) in a backup table. Assume you have the two tables created: CONTACTS and
CONTACTS_BACKUP. These two (2) tables have the same records.
The CONTACTS table have the following columns: CONTACT_ID (Primary_Key), FIRSTNAME, LASTNAME and MOBILE_NO.
CONTACTS_ID
FIRSTNAME
LASTNAME
MOBILE_NO
1
100
Princess
Kim
813023895
2
101
Henry
Packer
811257891
3
102
Petrus
Johannes
855698712
4
103
Lukas
Shilongo
832584691
The CONTACTS_BACKUP table have the same columns and records as the CONTACTS table.
CONTACTS_ID
FIRSTNAME
LASTNAME
MOBILE_NO
100
Princess
Kim
813023895
2
101
Henry
Packer
811257891
3
102
Petrus
Johannes
855698712
4
103
Lukas
Shilongo
832584691
You now need to keep both tables in sync so that when a record is inserted into the CONTACTS table it should automatically be inserted into…
Which of the following are true about primary keys? SELECT ALL THAT APPLY.
A) They must reference one or more columns in a single table.
B) They are usually implemented using an index.
C) They guarantee that no two rows in a table have duplicate primary key values.
D) They must be defined for every database table.
For on ordered file based on key attribute, the following index can be created:
O Clustering.
O Primary.
Secondary.
Chapter 1 Solutions
Oracle 12c: SQL
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Discuss the problems that can be caused by data...Ch. 1 - Explain the role of a primary key.Ch. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - What type of relationship can’t be stored in a...Ch. 1 - Identify at least three reasons an organization...
Ch. 1 - Prob. 1MCCh. 1 - Prob. 2MCCh. 1 - Prob. 3MCCh. 1 - Prob. 4MCCh. 1 - Prob. 5MCCh. 1 - Prob. 6MCCh. 1 - Prob. 7MCCh. 1 - Which of the following has no partial or...Ch. 1 - Prob. 9MCCh. 1 - Which of the following has no partial dependencies...Ch. 1 - Which of the following has no repeating groups but...Ch. 1 - Prob. 12MCCh. 1 - Prob. 13MCCh. 1 - A unique identifier for a data row that consists...Ch. 1 - Which of the following symbols represents an...Ch. 1 - Prob. 16MCCh. 1 - Which of the following represents a field in a...Ch. 1 - Which of the following defines a relationship in...Ch. 1 - When part of the data in a table depends on a...Ch. 1 - Which of the following is used to join data...Ch. 1 - Which tables and fields would you access to...Ch. 1 - Prob. 2HOACh. 1 - Prob. 3HOACh. 1 - Prob. 4HOACh. 1 - Access path A database table is composed of...Ch. 1 - Prob. 6HOACh. 1 - Prob. 7HOACh. 1 - Prob. 8HOACh. 1 - Prob. 9HOACh. 1 - Prob. 10HOA
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- The following normal form preserves all functional dependencies A. 4NF B. 3NF C. BCNF D. 2NFarrow_forwardIn this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text. Here is the table structure: CREATE TABLE USER_ ( USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (USER_ID) ); CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL, PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR ( SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…arrow_forwardINFO 2103 Assignment #2 Subject: Database Programming For this assignment, please use the DOCTOR and PATIENT table. The script is available in both iTaleemC and GC. Script name: hospital.sql/hospital.rtf. Use INSTR to find the position of character ‘a’ in the doctor’s name. 2. CONCAT the patients’ first and last name and display their DOB in the following format ‘DD, Month YYYY’. Sort the patients’ name alphabetically. PATNAME NEWDOB Allen Mcginnis 3, May 1959 Anthony Rogers 7, December 2041 Becky Roach 8, September 1975 Brian Anderson 6, March 2048 Chasity Wright 23, April 1973 Debbie Saillez 9, September 1955 J.C. Jones 17, July 2002 Jason Smith 12, December 1999 Jennifer Poole 13, May 2002 Joe Sakic 16, September 1976 John Cochran 3, March 2048 John Jackson 14, October 2043 Keith Vanderchuck 8, August 1968 Lewis Crow 16, October 2049 Linda Davis 17, July 2002 Lynn…arrow_forward
- IMDB database that match those search criteria. Your program must include the following requirements: Connect to the same database server, using the same account as in the IMDB browser (the server is cisdbss.pcc.edu, and the username and password are 275student). Write a program that fetches data about a particular name from the NAMES database. Use the NAMES database on that server instead of the IMDB database, and modify your query. Here's an example query that should produce reasonable results: SELECT Name, Year, Gender, NameCount, Total FROM all_data WHERE Name = 'Marc' AND Gender = 'M' ORDER BY Year; Running the query should fetch the following data - only the first five rows are shown: Name Year Gender NameCount Total 1 Marc 1915 M 13 848603 2 Marc 1916 M 14 890099 3 Marc 1917 M 9 925511 4 Marc 1918 M 18 1013537 5 Marc 1919 M 17 980149 The user should be able to enter a name and a gender, and…arrow_forwardQ: Step 1. You have been asked to add code in given template file “app.py” to enable login using employee table in test database. First Create Data Base: test Create table: employee Table fields: Id Int 10(primary key) auto increment username Varchar 25 Password Varchar 25 EmpMail Varchar 25 With 2 records 1 Manager Manager123 manager@gmail.com 2 Teller Teller123 teller@gmail.com Login should have username and password field. You are asked to add SQL code to get successful login. Step 2. you should also add error message if credentials are wrong-Validation step Step 3: Add code to login .html template file to create Login form using text and password fields. Step 4. Add button to get sign-in action Step 5: you should save the file in relevant locations to avoid path and output issues. Step 6. You should have proper database connectivity to succeed in this lab worksheet. Successful connection to database also will be…arrow_forward● Create a python file called database_manip.py. Write the code to do the following tasks: ○ Create a table called python_programming. ○ Insert the following new rows into the python_programming table: id name grade 55 Carl Davis 61 66 Dennis Fredrickson 88 77 Jane Richards 78 12 Peyton Sawyer 45 2 Lucas Brooke 99 ○ Select all records with a grade between 60 and 80. ○ Change Carl Davis’s grade to 65. ○ Delete Dennis Fredrickson’s row. ○ Change the grade of all people with an id below than 55.arrow_forward
- Database Access Code Write the codethe best that you can to execute the following SQLstatement against a database. Your code should read thedata from the DB and print out all of the data. Thedatabase is an Access database, setup with an ODBCname of "AccountingDB'. Do the best you can, partialcredit will be given. Put your code in the main methodgiven below. [Hint: SQL will return all accounts from thedatabase.]SOL = "Select AcctNo, Owner, Balance fromAccounts"public static void main (String args[])arrow_forwardWhich type of database constraint does the following trigger implement? a.Key constraint b.Dynamic integrity constraint c.Static integrity constraint d.Inter-relational integrity constraintarrow_forwardTask question: Step 1. You have been asked to add code in given template file “app.py” to enable login using employee table in test database. First Create Data Base: test Create table: employee Table fields: Id Int 10(primary key) auto increment username Varchar 25 Password Varchar 25 EmpMail Varchar 25 With 2 records 1 Manager Manager123 manager@gmail.com 2 Teller Teller123 teller@gmail.com Login should have username and password field. You are asked to add SQL code to get successful login. Step 2. you should also add error message if credentials are wrong-Validation step Step 3: Add code to login .html template file to create Login form using text and password fields. Step 4. Add button to get sign-in action Step 5: you should save the file in relevant locations to avoid path and output issues. Step 6. You should have proper database connectivity to succeed in this lab worksheet. Successful connection to database…arrow_forward
- Which of the following has no repeating groups but can contain partial or transitive dependencies?a. unnormalized datab. 1NFc. 2NFd. 3NFarrow_forwardSQL Queries Specify the following SQLite queries on the chinook database. A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine. SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document. There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others. Queries to Specify 1. List the last name, postal code and country for all customers from Germany. 2. List the city and number of customers from each city. 3. List the customer id, last name and city for the first 20 customers, when they are ordered by last name ascending. 4. List the customer id, last name and company for all customers who have any company details recorded (the company attribute is not "null").…arrow_forwardAnswer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The 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…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY