Computer Science: An Overview (13th Edition) (What's New in Computer Science)
13th Edition
ISBN: 9780134875460
Author: Glenn Brookshear, Dennis Brylow
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 10CRP
Program Plan Intro
Relational
- A database Management System is a software application for managing the database in a well-organized form.
- It provides a systematic way to create, retrieve and update the database.
- In DBMS, the schema explains the logical structure of the data base system.
- It provides the capability to the user to self-analyze the database and perform the necessary operations.
- A relational database comprises of rectangular tables known as relations.
- Every row in relation is known as tuple.
- Each column in table is termed as field or attribute.
- It describes the characteristics of entity represented by corresponding tuple.
Relational database design process:
- It is designed to meet requirements of particular application.
- There are no two databases that are alike.
- The design choice is based on user preference.
- The steps used in this process includes:
- Step 1 – Define the database purpose
- Step 2 – Gather data and organize in table
- Step 3 – Refine and normalize design, it includes adding columns, creating new relation and splitting large relation into smaller relations.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Every flimsy entity set may be strengthened by the addition of pertinent characteristics. What therefore, is the cause of our subpar entity sets?
The distinction between a weak and a strong entity collection has to be clarified.
Build an entity-relationship diagram, deriving relations and validating relations using normalization up to third normal form
Chapter 9 Solutions
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Ch. 9.1 - Identify two departments in a manufacturing plant...Ch. 9.1 - Prob. 2QECh. 9.1 - Summarize the roles of the application software...Ch. 9.2 - Prob. 1QECh. 9.2 - Prob. 2QECh. 9.2 - Prob. 4QECh. 9.2 - Prob. 5QECh. 9.2 - Prob. 6QECh. 9.3 - Prob. 1QECh. 9.3 - What is a persistent object?
Ch. 9.3 - Identify some classes as well as some of their...Ch. 9.3 - Prob. 4QECh. 9.4 - Prob. 1QECh. 9.4 - Prob. 2QECh. 9.4 - Prob. 3QECh. 9.4 - Prob. 4QECh. 9.4 - Prob. 5QECh. 9.4 - Prob. 6QECh. 9.5 - Prob. 1QECh. 9.5 - Prob. 2QECh. 9.5 - Prob. 3QECh. 9.5 - Prob. 4QECh. 9.5 - Prob. 5QECh. 9.5 - Prob. 6QECh. 9.5 - Prob. 7QECh. 9.6 - Prob. 1QECh. 9.6 - Give an additional example of a pattern that might...Ch. 9.6 - Prob. 3QECh. 9.6 - How does data mining differ from traditional...Ch. 9.7 - Prob. 1QECh. 9.7 - Prob. 2QECh. 9.7 - Prob. 3QECh. 9.7 - Prob. 4QECh. 9 - Prob. 1CRPCh. 9 - Prob. 2CRPCh. 9 - Prob. 3CRPCh. 9 - Prob. 4CRPCh. 9 - Prob. 5CRPCh. 9 - Prob. 6CRPCh. 9 - Prob. 7CRPCh. 9 - Prob. 8CRPCh. 9 - Prob. 9CRPCh. 9 - Prob. 10CRPCh. 9 - Prob. 11CRPCh. 9 - Prob. 12CRPCh. 9 - Using the commands SELECT, PROJECT, and JOIN,...Ch. 9 - Answer Problem 13 using SQL. PROBLEM 13 13. Using...Ch. 9 - Prob. 15CRPCh. 9 - Prob. 16CRPCh. 9 - Prob. 17CRPCh. 9 - Prob. 18CRPCh. 9 - Prob. 19CRPCh. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Empl Id Name Address SSN Job Id Job Title Skill...Ch. 9 - Prob. 22CRPCh. 9 - Prob. 23CRPCh. 9 - Prob. 24CRPCh. 9 - Prob. 25CRPCh. 9 - Write a sequence of instructions (using the...Ch. 9 - Prob. 27CRPCh. 9 - Prob. 28CRPCh. 9 - Prob. 29CRPCh. 9 - Prob. 30CRPCh. 9 - Prob. 31CRPCh. 9 - Prob. 32CRPCh. 9 - Prob. 33CRPCh. 9 - Prob. 34CRPCh. 9 - Prob. 35CRPCh. 9 - Prob. 36CRPCh. 9 - Prob. 37CRPCh. 9 - Prob. 38CRPCh. 9 - Prob. 39CRPCh. 9 - Prob. 40CRPCh. 9 - Prob. 41CRPCh. 9 - Prob. 42CRPCh. 9 - Prob. 43CRPCh. 9 - Prob. 44CRPCh. 9 - Prob. 45CRPCh. 9 - Prob. 46CRPCh. 9 - Prob. 47CRPCh. 9 - Prob. 48CRPCh. 9 - Prob. 49CRPCh. 9 - Prob. 50CRPCh. 9 - Prob. 51CRPCh. 9 - Prob. 52CRPCh. 9 - Prob. 53CRPCh. 9 - Prob. 54CRPCh. 9 - Prob. 55CRPCh. 9 - Prob. 56CRPCh. 9 - Prob. 57CRPCh. 9 - Prob. 58CRPCh. 9 - Prob. 59CRPCh. 9 - Prob. 60CRPCh. 9 - Prob. 61CRPCh. 9 - Prob. 62CRPCh. 9 - Prob. 1SICh. 9 - Prob. 2SICh. 9 - Prob. 3SICh. 9 - Prob. 4SICh. 9 - Prob. 5SICh. 9 - Prob. 6SICh. 9 - Prob. 7SICh. 9 - Prob. 8SICh. 9 - Prob. 9SICh. 9 - Prob. 10SI
Knowledge Booster
Similar questions
- The distinction between a weak and a strong entity set is best explained here.arrow_forwardQuestion 1: Normalization PLEASE WRITE ELIGIBLE AND SHOW FULL STEPS FOR DIAGRAM TO DECOMPOSE Consider a relation X with six attributes WYSMFE where WS is a composite primary key for X. Assume X has the following functional dependencies (X is one table with the attributes W, Y, S, M, F, E): WS è YMFE S è YME E è M Is it possible to decompose X into a number of relations in order to achieve a higher normal form? Explain how (this means using English sentences and a diagram showing the final relation(s)).arrow_forwardTransform an entity-relationship (E-R) diagraminto an equivalent set of well-structured(normalized) relations.arrow_forward
- Given the following relation R and its functional dependencies: R(workerNumber, machineNumber, spentTime, repairDate, machineName, workshopNumber, workshopName ) repairNumber, workerName, workerNumber à workerName repairNumber à repairDate, machineNumber machineNumber à machineName, workshopNumber workshopNumber à workshopName 1) Explain the types of all the dependencies in the relation R.arrow_forwardDistinguish between the ways in which functional dependencies may be utilized to express the following: • Between the entity sets student and teacher, there is a one-to-one relationship set that exists.• There is a many-to-one connection set between the entity setsstudent and teacher, which is defined asarrow_forwardConsider two entity sets A and B that both have the attribute X (among otherswhose names are not relevant to this question). If the two Xs are completely unrelated, how should the design be improved?arrow_forward
- Specifically, on which side of a many-to-one connection does the primary key of one entity function as a foreign key? There is a huge number of relationships specified on one side of the diagram. both from the inside and the outside It is possible to define two relationships at the same time. On the one hand, one connection is defined; on the other, another relationship is defined.arrow_forwardA well-structured database starts from an effective Entity Relationship Diagram (ERD). For this part of the question, you will need to sketch an ERD for the following gym scenario: A member must have a member ID, name and contact number, can be enrolled in one or more gym session. A gym session can be enrolled in by one or more members. Each gym session is identified by a session ID, and has a name, date and instructor details (Instructor ID). An instructor has an instructor ID, name and contact number, and must only be assigned to one gym session. A gym session can have one or more instructors assigned in it.” *show entities, relationship types and cardinalities. Crow’s foot model notations recommended.arrow_forwardConsider two entity sets A and B that both have the attribute X (among otherswhose names are not relevant to this question). If the two Xs represent the same property and it is one that applies both to A and to B, how should the design be improved? Consider three subcases: • X is the primary key for A but not B • X is the primary key for both A and B • X is not the primary key for A nor for Barrow_forward
- Draw an ER diagram expressing the total participation of an entity type “BURGER” in a binary relation “CONTAINS” with an entity type “INGREDIENT”. What would be the cardinality on each side of the relationship (indicate both max and min)?arrow_forwardConstruct an (E)ER diagram for a hospital system with the following requirements: Patients are described using unique ss# as well as name, insurance, admitted date, and checked-out date Doctors are described using unique dss# as well as their names and specialization. Each patient may have a set of tests, described by test id, test name, date, time, and results. These tests are performed by doctors. Then convert the (E)ER diagram to a collection of relation tables (Relational database schema). Determine all the primary and foreign keys.arrow_forwardConsider two entity sets A and B that both have the attribute X (among otherswhose names are not relevant to this question).a. If the two Xs are completely unrelated, how should the design be improved?b. If the two Xs represent the same property and it is one that applies both toA and to B, how should the design be improved? Consider three subcases:• X is the primary key for A but not B• X is the primary key for both A and B• X is not the primary key for A nor for Barrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning