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…
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;$$;
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
- The following normal form preserves all functional dependencies A. 4NF B. 3NF C. BCNF D. 2NFarrow_forwardWhich of the following has no repeating groups but can contain partial or transitive dependencies? unnormalized data 1NF 2NF 3NFarrow_forwardFor on ordered file based on key attribute, the following index can be created: O Clustering. O Primary. Secondary.arrow_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_forwardConsider 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_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
- SQL 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 5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address. 6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks. 7. Find the maximum track length in milliseconds. 8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive 9. List the…arrow_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_forwardExplain in your own words: a.) What is metadata? b.) What is result set metadata? c.) When is result set metadata useful?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