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 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 solutionStudents have asked these similar questions
Which of the following is NOT a mechanism to de-identify data?
A. Aggregation.B. Interpolation.C. Obfuscation.D. Truncation.
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 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
- 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.arrow_forwardWhen you use the word "metadata," what precisely do you mean by that? The following is an explanation of what metadata is in the context of a data set: When may it be advantageous to make use of the metadata that has been taken from a result set?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
- Hi, I am looking for some help to solve this question. I cannot figure out how to solve it and the code below is all I have. The application being used: PostgreSQL edition 12 or 13. I must use LANGUAGE PLPGSLQ as that is what the professor is looking for. Thank you for your help. Tables in the DB:instructor (id, name, dept_name, salary)teaches (id, course_id, sec_id, semester, year) CREATE TEMPORARY TABLE instructor_course_nums (ID VARCHAR(5),name VARCHAR(20),tot_courses INTEGER); CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))LANGUAGE PLPGSQLAS$$BEGINSELECT name INTO instructor.name FROM instructor WHERE instructor.id = i_id;SELECT COUNT(*) INTO course FROM teaches WHERE teaches.id = i_id;SELECT COUNT(*) INTO l_Exist_count FROM instructor_course_nums WHERE instructor_id= i_id;END;$$;arrow_forwardWhich of the following has no repeating groups but can contain partial or transitive dependencies? unnormalized data 1NF 2NF 3NFarrow_forwardMC 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_forward
- Consider the following table then answer the following questions? Stld StName StPhone 1122 Salim 12345 3344 Amani 67890,11223 5566 Asma 89897 1- Is this table in one of the normal forms? Which one? 2- Convert the table to one of the normal forms? (upload the answer file)arrow_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_forwardI was hoping you could provide some light on the role that the data dictionary plays in the DBLC method.arrow_forward
- 1. Create the table with the following specification shown below: Database name: Oasis. Table name : Employees EMPLOYEES INFORMATION EID NAME JOB SALARY E111 SMITH PROGRAMMER 1200 E112 JOHN CLERK 1200 E113 FORD ANALYST 500 E114 JAMES ENGINEER 700 Write php code dynamically to perform the following: a) Establish the database connection. b) To Add/insertall the records. c) Update the record based on EIDarrow_forwardanswer question in photo plsarrow_forwardWhen you say "metadata," what do you mean exactly? In the context of a data set, the following is a definition of metadata: When might it be helpful to use information pulled from a set of 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