Principles of Information Systems (MindTap Course List)
13th Edition
ISBN: 9781305971776
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 5, Problem 5SAT
The ability to combine two or more tables through common data attributes to form a new table with only the unique data attributes is called _______________.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Assignment Brief:
Some of the most difficult decisions that you face as a database developer are what tables to
create and what columns to place in each table, as well as how to relate the tables that you
create. Normalization is the process of applying a series of rules to ensure that your database
achieves optimal structure. Normal forms are a progression of these rules. Each successive
normal form achieves a better database design than the previous form did. Based on your
understanding for the various normal form respond to the following problems and provide the
optimal answer/solution.
Problem#1: 1st Normal Form (1NF)
Consider the Students table, with the primary key underlined, and the following data:
Students:
Alpha
100111
Email
doe@usna.edu
Name
Courses
GradePoints
NN204, SI204,
IT221
SM223, EE301
SI204
John Doe
2,3,3
Matt Smith
092244
113221
smith@usna.edu
black@usna.edu
4,4
Melinda
3
Black
NN204, SI204,
IT221
090112
Tom Johnson
Johnson@usna.ed
4,2,3
u
a) Is the Students table…
Data standardization usually focuses on fixing _ of data while data cleaning usually focuses on fixing _ of data.
A- The entity; data dictionary
B- The attribute; the entity
C- The entity; the attribute
D- Data dictionary; the entity
T. Relational Model
Instructions
This assignment will show that you understand how columns should be separated between tables in a properly structured
relational database.
Your objective:
Imagine you need to design a database that tracks members, type of membership, and exercise routines for each
member.
• Build a relational database model with multiple tables
• Use your imagination and feel free to create the tables with as many columns as you would like.
• Highest points will be awarded for completeness AND correctness.
Submit as an Excel workbook or image.
Chapter 5 Solutions
Principles of Information Systems (MindTap Course List)
Ch. 5.1 - Prob. 1RQCh. 5.1 - Which attribute would you designate as the primary...Ch. 5.1 - Prob. 1CTQCh. 5.1 - Prob. 2CTQCh. 5.2 - Prob. 1RQCh. 5.2 - Prob. 2RQCh. 5.2 - Prob. 1CTQCh. 5.2 - Prob. 2CTQCh. 5.3 - Prob. 1RQCh. 5.3 - Prob. 2RQ
Ch. 5.3 - What additional questions need to be answered...Ch. 5.3 - Prob. 2CTQCh. 5.4 - Prob. 1RQCh. 5.4 - Telefonica Brasil is one of the largest...Ch. 5.4 - Prob. 1CTQCh. 5.4 - Prob. 2CTQCh. 5.5 - Prob. 1RQCh. 5.5 - Prob. 2RQCh. 5.5 - Why is it unlikely that a traditional SQL database...Ch. 5.5 - Prob. 2CTQCh. 5 - Prob. 1SATCh. 5 - Prob. 2SATCh. 5 - Prob. 3SATCh. 5 - The ______________ model is a simple but highly...Ch. 5 - The ability to combine two or more tables through...Ch. 5 - Prob. 6SATCh. 5 - Prob. 7SATCh. 5 - Prob. 8SATCh. 5 - Prob. 9SATCh. 5 - Prob. 10SATCh. 5 - Prob. 11SATCh. 5 - Prob. 12SATCh. 5 - Prob. 13SATCh. 5 - Prob. 14SATCh. 5 - Prob. 15SATCh. 5 - Prob. 16SATCh. 5 - Prob. 1RQCh. 5 - In the hierarchy of data, what is the difference...Ch. 5 - Prob. 3RQCh. 5 - What is meant by data archiving? Why is this an...Ch. 5 - What is an entity-relationship diagram, and what...Ch. 5 - Identify four basic data manipulations performed...Ch. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - Prob. 17RQCh. 5 - Prob. 1DQCh. 5 - Outline some specific steps an organization might...Ch. 5 - SQL databases conform to ACID properties. Briefly...Ch. 5 - Prob. 4DQCh. 5 - Prob. 6DQCh. 5 - Prob. 8DQCh. 5 - Prob. 1PSECh. 5 - Describe the role of a database administrator....Ch. 5 - Prob. 2CECh. 5 - Prob. 1CTQ1Ch. 5 - Prob. 2CTQ1Ch. 5 - Prob. 3CTQ1Ch. 5 - Prob. 1CTQ2Ch. 5 - Prob. 2CTQ2Ch. 5 - Prob. 3CTQ2
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
- In the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?arrow_forwardQUESTION 2 Hillar Furniture Enterprise is a furniture store owned by Dr. Hillar Addo of AIT. The materials manager of this company maintains a list of suppliers for each of the materials items purchased by the company from outside vendors. The following table shows the essential data required for this application. Hillar Furniture Company Purchasing Data is shown below: Attribute Name Material_ID Material_ Name Unit_of_Measure Standard_Cost Vendor_ID Vendor_name Unit_price Terms_Code Terms Sample Value 3792 Hinges 3” locking Each GHC 5.00 V300 Apex Hardware GHC 4.75 1 COD a) Using the dependency diagram, identify the functional dependencies for this data. You may assume the following: Each material has one or more suppliers. Each supplier may have supply one or more items or may not supply many items. The unit price for a material may vary from one vendor to another The terms of a code for a supplier uniquely identifies the terms of a sale (e.g. code 2…arrow_forwardWhat is the difference between a data attribute and a data item in the data hierarchy? What is an attribute's scope?arrow_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_forwardWhich phase of complex database development adds indexes and specidfies how tables are organized on storage media? a) Logical Design b) Analysis c) Physical Design d) Functional Dependencearrow_forwardCreate the Database Schema, the Normalize table, and the Final ERDarrow_forward
- How can you, as a database designer, affect your database's performance in certain use scenarios? Which strategy is the most crucial for doing this?arrow_forwardDatabase Designs Using the types of entities found in the attached database (trips, guides, customers, and reservations), create an example of a table that is in first normal form but not in second normal form, justify your answer and show how to convert to the higher formsarrow_forwardConsider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno M WORKS ON Esan Pno Hours PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraintsarrow_forward
- key attribute(s) is Select one: O a. An attribute or set of attributes that allow users to log in to database O b. An attribute or set of attributes that uniquely identifies an a relationship in ER Diagram O c. An attribute or set of attributes that uniquely identifies an entity( uniquely identifies each record in a table) O d. An attribute or set of attributes that uniquely identifies ER Diagramarrow_forwardplease fast its database i need it nowarrow_forwardThe data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary. a. manipulation b. definition c. administration d. generationarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
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