Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 1, Problem 1.11RQ
Break the list in Figure 1-34 into two tables, each with data for a single theme. Assume that owners have a unique phone number but that pets have no unique column. Create an ID column for pets like the one created for customers and courses for the Art Course
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Based on the picture, create the ERD for this database. Then explain if the tables exhibit referential or entity integrity? Finally, Identify the TRUCK table’s candidate keys
When considering creating a join between two tables, how are we demonstrating the concept of "relational" databases? Why is it essential to create the join by finding a unique, unique attribute in at least one table and looking at situations where that attribute has the same value ( is equal ) in both tables?
Transform the table into 1NF, 2NF, and 3NF. Create a database diagram afterward
Chapter 1 Solutions
Database Concepts (8th Edition)
Ch. 1 - Prob. 1.1RQCh. 1 - Prob. 1.2RQCh. 1 - Prob. 1.3RQCh. 1 - Why is the study of database technology important?Ch. 1 - Prob. 1.5RQCh. 1 - Describe the purpose of a database.Ch. 1 - Prob. 1.7RQCh. 1 - Prob. 1.8RQCh. 1 - Prob. 1.9RQCh. 1 - Prob. 1.10RQ
Ch. 1 - Break the list in Figure 1-34 into two tables,...Ch. 1 - Show how the tables you created for question 1.11...Ch. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Break the list in Figure 1-35 into tables, each...Ch. 1 - Describe in your own words and illustrate with...Ch. 1 - Prob. 1.18RQCh. 1 - Define the term database.Ch. 1 - Prob. 1.20RQCh. 1 - List the components of a database.Ch. 1 - Prob. 1.22RQCh. 1 - Prob. 1.23RQCh. 1 - Prob. 1.24RQCh. 1 - What is the purpose of a DBMS?Ch. 1 - List the specific functions of a DBMS.Ch. 1 - Define the term referential integrity constraint....Ch. 1 - Prob. 1.28RQCh. 1 - List the functions of a database application.Ch. 1 - Prob. 1.30RQCh. 1 - Prob. 1.31RQCh. 1 - Prob. 1.32RQCh. 1 - Prob. 1.33RQCh. 1 - Prob. 1.34RQCh. 1 - Prob. 1.35RQCh. 1 - Prob. 1.36RQCh. 1 - Prob. 1.37ECh. 1 - Prob. 1.38ECh. 1 - Prob. 1.39E
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Why might doctors and nutritionists be interested in a device like DietSensor?
Using MIS (10th Edition)
Porter’s competitive forces model: The model is used to provide a general view about the firms, the competitors...
Management Information Systems: Managing The Digital Firm (16th Edition)
Are reflex actions (such as flinching from a hot stove) rational? Are they intelligent?
Artificial Intelligence: A Modern Approach
If the following statement were used in a Java program, it would cause something to be written to the screen. W...
Absolute Java (6th Edition)
PERSON AND CUSTOMER Classes Design a class named Person with properties for holding a persons name, address, an...
Starting Out With Visual C# (5th Edition)
Give a Java statement that will display a dialog window on the screen with the message I Love You.
Java: An Introduction to Problem Solving and Programming (8th Edition)
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
- For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLESarrow_forwardDo the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. FIGURE P3.17 THE CH03_TRANSCO DATABASE TABLESarrow_forwardWhen considering creating a join between two tables, how are we demonstrating the concept of "relational" databases? Why is it essential that we create the join by finding a common attribute that is unique in at least one table and look at situations where that attribute has the same value ( is equal ) in both tables?arrow_forward
- Normalize the dessert table database shown in ER diagram below (Figure1) up to at least 3NF.arrow_forwardRealtional database SQL question 14) If Tables T1 and T2 are connected as „one to one” than : Both tables must have the same number of records Entity on one side has a primary key which is the same time as a foreign key For both entities attribute being a primaary key is also a foreign key There are no limits to numer of records in both tablesarrow_forwardWhich of the following is false: A. Tables are joined by using primary key/foreign key combinations B. A primary key can consist of more than one attribute C. A primary key can only be the foreign key of another table D. The number of tables in a relational database can be greater than the number of entities in the corresponding REA diagramarrow_forward
- If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database iteration if the current design has more than 95% of tables with a 1:1 relationship? Combine some tables together. Create more 1:M relationships. Create more M:N relationship. Leave the database design as isarrow_forward) Consider the bank database schema shown below (see the textual description below).Assume that branch names uniquely identify branches. Also assume that loans andaccounts can be associated with more than one customer.Format:tableName ( attributes )Banking Database Schema:branch ( branch_name, branch_city, assets )customer ( cust_ID, customer_name, customer_street, customer_city )loan ( loan_number, branch_name, amount )borrower ( cust_ID, loan_number )account ( account_number, branch_name, balance )depositor ( cust_ID, account_number )a. What are the appropriate primary keys? Indicate the appropriate primary keys bycopying-and-pasting the above schema and underlining the primary key attributes.b. Given your choice of primary keys, identify appropriate foreign keys (i.e. identifyattributes in referencing and referenced relations). You can state the foreign keyconstraints in words. For example, “For loan relation: branch_name attributereferencing branch relation.”c. Construct a…arrow_forwardI need you solve this question (Based on the Un-Normalized database table below, create a data model for a Rental Caragency by normalizing them with 2nd and 3rd normal forms.) i need you to complete just like the second image in hand writtenarrow_forward
- Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…arrow_forwardImplement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY