Solution Manual for Fundamentals of Database Systems , 7th Edition

Solution Manual for Fundamentals of Database Systems , 7th Edition gives you the answers you need, explained in a simple and clear way.

Victoria Lee

Contributor

4.1

10 months ago

Preview (31 of 150 Pages)

100%

Purchase to unlock

Solution Manual for Fundamentals of Database Systems , 7th Edition - Page 1 preview image

Loading page ...

Chapter 1: Databases and Database Users1CHAPTER 1: DATABASES AND DATABASE USERSAnswers to Selected Exercises1.8-Identify some informalqueries and update operationsthat you would expect to apply tothe database shown in Figure 1.2.Answer:(a) (Query) List the names of all students majoring in Computer Science.(b) (Query) What are the prerequisites of the Database course?(c) (Query) Retrieve the transcript of Smith. This is a list of <CourseName,SectionIdentifier, Semester, Year, Grade> for each course section that Smith hascompleted.(d) (Update) Insert a new student in the database whose Name=Jackson,StudentNumber=23, Class=1 (freshman), and Major=MATH.(e) (Update) Change the grade that Smith received in Intro to Computer Science section119 to B.1.9-What is the difference between controlled and uncontrolled redundancy?Answer:Redundancy is when the same fact is stored multiple times in several places in a database.For example, in Figure 1.5(a) the fact that the name of the student with StudentNumber=8 isBrown is stored multiple times. Redundancy is controlled when the DBMS ensures thatmultiple copies of the same data are consistent; for example, if a new record withStudentNumber=8 is stored in the database of Figure 1.5(a), the DBMS will ensure thatStudentName=Smith in that record. If the DBMS has no control over this, we haveuncontrolled redundancy.1.10-Specify all the relationships among the records of the database shown in Figure 1.2.Answer:(a) Each SECTION record is related to a COURSE record.(b) Each GRADE_REPORT record is related to one STUDENT record and one SECTIONrecord.(c) Each PREREQUISITE record relates two COURSE records: one in the role of a courseand the other in the role of a prerequisite to that course.1.11-Give some additional views that may be needed by other user groups for the databaseshown in Figure 1.2.Answer:(a) A view that groups all the students who took each section and gives each student'sgrade. This may be useful for printing the grade report for each section for theuniversityadministration's use.

Preview Mode

This document has 150 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

Fundamentals Of Database Systems by...

Solution Manual for Fundamentals of Database Systems , 7th Edition

Study Now!

Document Details

Related Documents

Solution Manual For Fundamentals Of Database Systems, 6th 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