Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
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 solution
Students have asked these similar questions
q6- Choose ALL that apply.
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.
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
- q4- Choose all that applyarrow_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_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
- Task 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_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_forwardPlease use C College StudentBibi is a lecturer who manages a student database at a university. Before Bibi existed, thestudent database was not well organized, and was not collected per student, so students’data could be chopped up and scattered irregularly between one another.Because Bibi is a lecturer who has studied “struct”, Bibi wants to store all the data givenin the struct. Making it easier to find and reuse.You are encouraged to use the struct method to solve this problem to make it easier tostore data.Data from students can contain:• Name (Nama)• NIM• Age (Umur)• Postal Code (Kode Pos)• Place of Birth (Tempat Lahir)• Date of Birth (Tanggal Lahir)• High School (Almamater SMA)• Number of Siblings (Jumlah Saudara Kandung)• Height (Tinggi Badan)• Bank Account Number (NOMOR REKENING)Format InputThe input in the first row contains an integer N , how much student data you have tosave. For the next N ×10 rows of student data you must save sequentially from the Nameuntil Account…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 of the following statements is true?a. A gap can appear in a sequence created with the NOCACHE option if the system crashes before a user can commit a transaction.b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary table as unassigned.c. Only the user who creates a sequence is allowed to delete it.d. Only the user who created a sequence is allowed to use the value enerated by the sequence.arrow_forwardWrite a SQL statement to create a view named 'IT_Club_Student' which will contain information about all the students acting in the IT club.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 Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable 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