Solution Manual For Oracle 12c: SQL, 3rd Edition

Solution Manual For Oracle 12c: SQL, 3rd Edition ensures you understand each concept clearly with textbook-based learning.

Benjamin Fisher

Contributor

4.0

6 months ago

Preview (16 of 69 Pages)

100%

Purchase to unlock

Solution Manual For Oracle 12c: SQL, 3rd Edition - Page 1 preview image

Loading page ...

Oracle12cSQL, ISBN:9781305251038Ch. 11Chapter 1 SolutionsReview Questions1.What is the purpose of an E-Rmodel?To identify the entities about which the databaseshould store data and the relationshipsamong those entities.2.What is an entity?An entity is any person, place, or thing having attributes, orcharacteristics, of interest to the organization.3.Give an example of three entities that might exist in a database for a medical office and someattributes that would be stored in a table for each entity.Doctor:name, address, SocialSecurity Number, medical ID number; Patient:name, address, Social Security Number,insurance policy information, medical history; Appointment:date, time, patient, doctor.4.Define a one-to-many relationship.An occurrence of data in one entitycanresult inzero,one,ormanyoccurrencesofthedata in the other entity.Zero(or no)related records canoccuronlyin optional relationships.5.Discuss the problems that can be caused by data redundancy.Can create data anomalies orinconsistencies in the data,making it unreliable.6.Explain the role of a primary key.The primary key is used to uniquely identify each row in atable.7.Describe how aforeign keyis different from a primary key.A foreign key is used toreference or join data in different tables. In most cases, the foreign key references a primarykey in another table. In a one-to-many relationship, the foreign key is stored in the “many”entity.8.List the steps of the normalization process.First, a primary key is identified and anyrepeating groups are identified(1NF).Second,any partial dependencies are eliminated(2NF).Third, any transitive dependencies are eliminated(3NF).9.What type of relationship can’t be stored in a database? Why?A many-to-many relationshipcan’t be stored in a databasebecausethere would be no way to restructure or rejoin the datacorrectly.10.Identify at least three reasons an organization might analyze historical sales data stored inits database.Answers will vary.To determine the necessary inventory levels to support salesfluctuations,toproject employee-scheduling requirements,todetermine appropriatemarketing campaigns based on historic purchasing patterns, and so forth.

Preview Mode

This document has 69 pages. Sign in to access the full document!

Report

Study Now!

XY-Copilot AI

Unlimited Access

Secure Payment

Instant Access

24/7 Support

Document Chat

Document Details

Subject

Information Technology

Textbook

Oracle 12c: SQL by Joan Casteel

Solution Manual For Oracle 12c: SQL, 3rd Edition

Study Now!

Document Details

Related Documents

Class Notes For Oracle 12c: SQL, 3rd Edition

DevOps and Its Importance Study Notes

Veeam Certified Engineer VMCE-V12

Modules 1 - 3 Basic Network Connectivity and Commu

Notes CCNA

CCNA 200-301 Portable Command Guide 5th Edition 20

CCNA 200-301 Portable Command Guide 5th Edition 22

CCNA 200-301 Portable Command Guide 5th Edition 36

Foundations of Novell Networking Section 26

Modulo 7 DHCPv4

Company

Explore

Study Tools