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 8MC
Which of the following has no partial or 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
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…
database ERD
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.
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
- Answer the questions using the database below. Tables and data contained in the database of a company that sells stationery products are given below. 1. Write the query listing the number and name of the customer who ordered the maximum quantity of the product named "Pen". When answering the questions, assume that each order will contain one type of product. PK: Primary Key FK: Foreign Key The queries should be prepared in MAMP program to run in MySQL. Trigger will be created by typing SQL command, not interfacearrow_forwardWhich 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.arrow_forward6. What's the Oracle package name used to implement FGA? Options are: (MCQ) a. DBA_FGA B. DBMS_RLS C. DBMS_FGA D. DBA_RLSarrow_forward
- MC 2 . Write an Anonymous PL/SQL block that will insert five records into the database; the records must include the "jpeg" binary files that contains the photographs associated with each record. One technique would be, Create BFILE locators for each of the image files Create 5 INSERT statements into the table CREATE TABLE StudentRecord ( FirstName VARCHAR2 (20) NOT NULL, LastName VARCHAR2 (40) NOT NULL, HomeworkAvg NUMBER(10,2), AttendanceAvg NUMBER (20,2), ExamAvg NUMBER (10,2), StudentID VARCHAR2 (10),arrow_forwardConvert this into normalization form. Like UNF, 1NF,2NF,3NF and4NF.arrow_forwardGiven the following relation: Book (BooklD, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables i. Display the fetched book author and title. T TTF Paragraph Arial 3 (12pt) ABC T T, e HTML CSS O f. Mashupsarrow_forward
- 3arrow_forwardWhich of the following statements is not true? a. First normal form (1NF): Table format, no repeating groups, and PK identified. O b. Second normal form (2NF): 1NF and no partial dependencies O c. Third normal form (3NF): 2NF and no transitive dependencies d. Boyce-Codd normal form (BCNF): Every determinant is a candidate key (special case of 3NF). O e. Fourth normal form (4NF): 3NF and no dependent multivalued dependencies.arrow_forwardWhich of the statements below is correct? a. Non-Oracle RDBMS use tablespaces as storage independent of database b. In Oracle, all users are given access to Tablespace. c. In Oracle, all instances use the same listener d. In Oracle, users who access the Database can all achieve the same results.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
C++ Programming: From Problem Analysis to Program...Computer ScienceISBN:9781337102087Author:D. S. MalikPublisher:Cengage Learning
C++ Programming: From Problem Analysis to Program...
Computer Science
ISBN:9781337102087
Author:D. S. Malik
Publisher:Cengage Learning
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY