Starting Out with Java: Early Objects (6th Edition)
6th Edition
ISBN: 9780134462011
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter 15, Problem 17MC
Program Description Answer
The column in one table that would refer a primary key in a different table is “foreign key”.
Hence, the correct answer is option “C”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following fields also serves as a primary key in another table when two tables are joined together on that value? a. foreign key b. primary key c. turn key d. repeating group key
The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City, State, ZipCode and MemberFee. The table contains 75,000 documents. How would you build indexes for the table and why would you create these indexes?
Which are the primary key in the following tables
Chapter 15 Solutions
Starting Out with Java: Early Objects (6th Edition)
Ch. 15.1 - Why do most businesses use a DBMS to store their...Ch. 15.1 - When a Java programmer uses a DBMS to store and...Ch. 15.1 - Prob. 15.3CPCh. 15.1 - Prob. 15.4CPCh. 15.1 - Prob. 15.5CPCh. 15.1 - Prob. 15.6CPCh. 15.1 - What static JDBC method do you call to get a...Ch. 15.2 - Describe how the data that is stored in a table is...Ch. 15.2 - What is a primary key?Ch. 15.2 - What Java data types correspond with the following...
Ch. 15.3 - Prob. 15.11CPCh. 15.3 - Prob. 15.12CPCh. 15.3 - Prob. 15.13CPCh. 15.3 - Prob. 15.14CPCh. 15.3 - What is the purpose of the % symbol in a character...Ch. 15.3 - How can you sort the results of a SELECT statement...Ch. 15.3 - Assume that the following declarations exist:...Ch. 15.3 - How do you submit a SELECT statement to the DBMS?Ch. 15.3 - Prob. 15.19CPCh. 15.3 - Prob. 15.20CPCh. 15.4 - Prob. 15.21CPCh. 15.4 - Prob. 15.22CPCh. 15.5 - The Midnight Coffee Roastery is running a special...Ch. 15.5 - Prob. 15.24CPCh. 15.6 - Prob. 15.25CPCh. 15.6 - Write a statement to delete the Book table you...Ch. 15 - Prob. 1MCCh. 15 - This is a standard language for working with...Ch. 15 - Prob. 3MCCh. 15 - The data that is stored in a row is divided...Ch. 15 - Prob. 5MCCh. 15 - This type of SQL statement is used to retrieve...Ch. 15 - This contains the results of an SQL SELECT...Ch. 15 - This clause allows you to specify search criteria...Ch. 15 - Prob. 9MCCh. 15 - Prob. 10MCCh. 15 - Prob. 11MCCh. 15 - Prob. 12MCCh. 15 - This method is specified in the Statement...Ch. 15 - This SQL statement is used to insert rows into a...Ch. 15 - This SQL statement is used to remove rows from a...Ch. 15 - Prob. 16MCCh. 15 - Prob. 17MCCh. 15 - True/False: Java comes with its own built-in DBMS.Ch. 15 - True/False: A Java programmer that uses a DBMS to...Ch. 15 - True/False: You use SQL instead of Java to write...Ch. 15 - True/False: In SQL, the not-equal-to operator is...Ch. 15 - Prob. 22TFCh. 15 - Prob. 23TFCh. 15 - Prob. 24TFCh. 15 - Prob. 1FTECh. 15 - Prob. 2FTECh. 15 - Prob. 3FTECh. 15 - What SQL data types correspond with the following...Ch. 15 - Look at the following SQL statement. SELECT Name...Ch. 15 - Write a SELECT statement that will return all of...Ch. 15 - Write a SELECT statement that will return the...Ch. 15 - Prob. 5AWCh. 15 - Write a SELECT statement that will return the...Ch. 15 - Write a SELECT statement that will return all of...Ch. 15 - Write a SELECT statement that will return the...Ch. 15 - Write a SELECT statement that will return the...Ch. 15 - Prob. 10AWCh. 15 - Write an SQL statement that does the following:...Ch. 15 - Prob. 12AWCh. 15 - Prob. 13AWCh. 15 - Assuming that conn references a valid Connection...Ch. 15 - Look at the following declaration. String sql =...Ch. 15 - Prob. 16AWCh. 15 - Prob. 17AWCh. 15 - Prob. 18AWCh. 15 - Prob. 1SACh. 15 - Prob. 2SACh. 15 - Prob. 3SACh. 15 - What is a primary key?Ch. 15 - Prob. 5SACh. 15 - What are the relational operators in SQL for the...Ch. 15 - What is the number of the first row in a table?...Ch. 15 - Prob. 8SACh. 15 - Prob. 9SACh. 15 - Customer Inserter Write an application that...Ch. 15 - Customer Updater Write an application that...Ch. 15 - Unpaid Order Sum Write an application that...Ch. 15 - Population Database Make sure you have downloaded...Ch. 15 - Personnel Database Creator Write an application...Ch. 15 - Employee Inserter Write a GUI application that...Ch. 15 - Employee Updater Write a GUI application that...
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 characters can be used in a table name? a. b. ( c. % d. !arrow_forwardA composite key is a column containing unique information. a. True b. Falsearrow_forwardSome rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles BD 11 Mary 877 - 3333 BD Which of the following queries retrieves the rows where there is no phone? a. SELECT * FROM User WHERE phone IS NULL b. SELECT * FROM User WHERE phone = “ ” c. SELECT * FROM User WHERE phone NOT IS NULL d. SELECT * FROM User WHERE phone > 0arrow_forward
- An index is automatically created for a FOREIGN KEY constraint. Select one: a. True b. Falsearrow_forwardThe COUNT(*) function in the SELECT clause is used to return:a. the number of records in the specified tablesb. the number of orders placed by each customerc. the number of NULL values in the specified tablesd. the number of customers who have placed an orderarrow_forwardThe database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDsarrow_forward
- Explain the difference between main key, candidate key, and superkey..arrow_forwardYou have a table that contains the following fields: MemberLastName, MemberFirstName, Street, City, State, ZipCode, and MembershipFee. There are 75,000 records in the table. What indexes would you create for the table, and why would you create these indexes?arrow_forwardThe database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.arrow_forward
- Given the tables: reading StationNo rainfall mintemp maxtemp 100 10 18 27 101 15 20 29 102 12 19 28 Stationregion station stationname 100 Savanne 101 Pamplemousses 102 Rose Belle (i) Write the statement to create the two table structures with the primary key as the field underlined. You may decide on the size of the fields. (ii) Write the statement to enter the data. (ii) Write the statement to display all the records with the fields station. stationname, mintemp, maxtemp .arrow_forwardUse the following table to answer the questions below: Table name: Customers Column Name Role Data Type Length Constraint customerID stores the ID of a Char 5 Primary key customer custFName stores the first name of a Varchar2 35 Cannot be null customer custLName Stores the last name of a Varchar2 35 Cannot be null customer custGender Store the gender of a Char 1 It should be M customer or 'F' custDOB Stores the date of birth of Date a customer custIncome Store the income of a Number customer d. Write a SQL query that displays the number of customers who born on the 16th day of a month e. Write in SQL a query that displays the ids of the customers who have the highest income f. Create a view named 'customerDetails' to hold all the details of customers whose first names start with 'S' and their incomes are between 500 and 1000 Omani Rialsarrow_forwardUse the following table to answer the questions below: Table name: Customers Column Name Role Data Type Length Constraint customerID stores the ID of a Char 5 Primary key customer custFName stores the first name of a Varchar2 35 Cannot be null customer custLName Stores the last name of a Varchar2 35 Cannot be null customer custGender Store the gender of a Char 1 It should be M customer or 'F' custDOB Stores the date of birth of Date a customer custIncome Store the income of a Number customer a. Write in SQL a command that creates the table Customers according to the above description b. Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account c. Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 d. Write a SQL query that displays the number of customers who born on the 16th day of a month e. Write in SQL a query that…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning