Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.41PAE
Program Plan Intro
Using indexes to access only records that satisfy the given qualification.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Let's pretend the Student table in a university database is indexed by StudentID (the primary key), Major, Age, MaritalStatus, and HomeZipCode (all secondary keys). Assume the school needed a list of students from the 45462 zip code who are either over the age of 25, married, and majoring in MIS or computer science OR who are above the age of 25 and majoring in computer engineering and are single. How can indexes be used to restrict access to records that exactly match these parameters?
Assume a university database's student table includes StudentID, Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). Assume the university wanted a list of MIS or computer science majors over 25 who were married and from 45462 OR computer engineering majors over 25 who were single. How can indexes guarantee only these records be accessed?
Let's pretend the Student table in a university database is indexed by StudentID
(the primary key), Major, Age, Marital Status, and HomeZipCode (all secondary
keys). Assume the school needed a list of students from the 45462 zip code
who are either over the age of 25, married, and majoring in MIS or computer
science OR who are above the age of 25 and majoring in computer engineering
and are single. How can indexes be used to restrict access to records that
exactly match these parameters?
Chapter 5 Solutions
Modern Database Management (12th Edition)
Ch. 5 - Prob. 5.1RQCh. 5 - Prob. 5.2RQCh. 5 - Prob. 5.3RQCh. 5 - Prob. 5.4RQCh. 5 - Prob. 5.5RQCh. 5 - Prob. 5.6RQCh. 5 - Prob. 5.7RQCh. 5 - Prob. 5.8RQCh. 5 - Explain why you sometimes have to reserve much...Ch. 5 - Why are field values sometimes coded?
Ch. 5 - Prob. 5.11RQCh. 5 - Prob. 5.12RQCh. 5 - Explain why normalized relations may not comprise...Ch. 5 - Prob. 5.14RQCh. 5 - List three common situations that suggest that...Ch. 5 - Explain the reasons why some experts are against...Ch. 5 - Prob. 5.17RQCh. 5 - Prob. 5.18RQCh. 5 - Prob. 5.19RQCh. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - State nine rules of thumb for choosing indexes.Ch. 5 - One of the strongest recommendations regarding...Ch. 5 - Explain why an index is useful only if there is...Ch. 5 - Indexing can clearly be very beneficial. Why...Ch. 5 - Consider the following two relations for...Ch. 5 - Prob. 5.28PAECh. 5 - Prob. 5.29PAECh. 5 - Prob. 5.30PAECh. 5 - Prob. 5.31PAECh. 5 - Suppose you are designing a default value for the...Ch. 5 - When a student has not chosen a major at a...Ch. 5 - Prob. 5.34PAECh. 5 - Prob. 5.35PAECh. 5 - Consider the relations in Problem and Exercise...Ch. 5 - Prob. 5.37PAECh. 5 - Prob. 5.38PAECh. 5 - Prob. 5.39PAECh. 5 - Prob. 5.40PAECh. 5 - Prob. 5.41PAECh. 5 - Consider the relations specified in Problem and...Ch. 5 - Prob. 5.43PAECh. 5 - Prob. 5.44PAECh. 5 - Prob. 5.45PAECh. 5 - Prob. 5.46PAECh. 5 - Prob. 5.47PAECh. 5 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 5 - Refer to the large Pine Valley Furniture Company...Ch. 5 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 5 - Refer to Figure 4-5 0. For each of the following...
Knowledge Booster
Similar questions
- An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a list of each employee’s name, job title, and manager’s name. Use column aliases to clearly identify employee and manager name values. Include all employees in the list and sort by manager name.arrow_forwardAssume a university database's student table has indexes on StudentID (the main key) and Major, Age, MaritalStatus, and HomeZipCode (all secondary keys) (all secondary keys). Imagine the university requested a list of students majoring in MIS or computer science who were over the age of 25, married, and from the 45462 zip code OR students majoring in computer engineering who were single and from the 45462 zip code. How can indexes be used to restrict results to to those records that fulfill this condition?arrow_forwardYou are asked to design a database for an University. This particular university has multipledepartments. Each department in that university offers one or more courses to the students. All thestudents are part of a certain department and they take courses in that department. A department hasa name, unique number and chairman. The courses have a name, a course number such as ‘311’ , acredit point value, and the year it commenced. A course cannot be identified uniquely with thecourse number, but the course number is unique for each department. Students have given names,surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a coursethe year and the semester he or she took that particular course is recorded. When he finishes thecourse , the grade and total marks are recorded. A student can take multiple courses but they are alsoallowed to drop a semester in that university by taking no courses. Construct an ER diagram usingthe requirements given here.…arrow_forward
- Assume a university database's student table has indexes on StudentID (the main key) and Major, Age, MaritalStatus, and HomeZipCode (all secondary keys). Assume the university required a list of students majoring in MIS or computer science who were above the age of 25, married, and from the 45462 zip code OR students majoring in computer engineering who were single and from the 45462 zip code. How can indexes be utilised to ensure that only records that meet this criteria are accessed?arrow_forwardYou are asked to design a database for an University. This particular university has multiple departments. Each department in that university offers one or more courses to the students. All the students are part of a certain department and they take courses in that department. A department has a name, unique number and chairman. The courses have a name, a course number such as ‘311’ , a credit point value, and the year it commenced. A course cannot be identified uniquely with the course number, but the course number is unique for each department. Students have given names, surname, unique Student ID, Date of Birth and the year they enrolled. When a student takes a course the year and the semester he or she took that particular course is recorded. When he finishes the course , the grade and total marks are recorded. A student can take multiple courses but they are also allowed to drop a semester in that university by taking no courses. Construct an ER diagram using the requirements…arrow_forwardAssume that the student table in the database of a university contains indexes on StudentID, which serves as the primary key, as well as Major, Age, MaritalStatus, and HomeZipCode (all secondary keys). Assume that the university needed a list of students who were over the age of 25, married, and from the 45462 zip code to major in MIS or computer science OR students who were majoring in computer engineering and were single and from the 45462 zip code to major in computer engineering. How can indexes be used to make sure that only entries that fulfill these requirements be accessible when they are needed?arrow_forward
- A database at a college must support the following requirements: a. For a department, store its number and name. b. For an advisor, store his or her number, last name, first name, and the department number to which the advisor is assigned. c. For a course, store its code and description (for example, DBA210, SQL Programming). d. For a student, store his or her number, first name, and last name. For each course the student takes, store the course code, course description, and grade earned. Also, store the number and name of the student's advisor. Assume that an advisor might advise any number of students but that each student has just one advisor. Design the database for the preceding set of requirements. Determine any functional dependencies. List the tables, columns, and relationships. In addition, represent your design with an E-R diagram.arrow_forwardScenario: The owner of Al Musana Hotel would like to have a database tables that will help him manage the clients and rooms in his building. He wants to record the information about his clients and its occupancy. The hotel has three different room types which are available for daily rent only. As the Database Designer, perform the following tasks to help the owner of the hotel: Create the CLIENTS table using the specification below: Table Name: CLIENTS Field Name/ Data Type column name Size Constraints CID Number 8 PRIMARY KEY CName Varchar2 25 NOT NULL Validate to accept Male or Female only Gender Varchar2 10 Address Varchar2 25 Contact Number 15 Стуре Varchar2 15arrow_forwardA select operation in a relational database decreases the size of a table by deleting columns that fulfill certain criteria.Is it correct or incorrect?arrow_forward
- Since no particular student is affiliated with a number, disclosing the total of all financial assistance for students in Smith dorm is not sensitive. Similarly, since no numbers are mentioned, a list of names of students seeking financial assistance is not sensitive. If only one student in Smith dorm requires funding, the sum of these two lists shows the number for an actual student. What calculations does a database management system have to make to figure out if the list of names contains classified information? What documents does the database management system need to keep on what particular people know in order to decide whether or not the list of names contains classified information?arrow_forwardUniversity laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equipment on each project. The organization would like to store the chemist's employee identification number, his name, upto three phone numbersb,this project identification number and the date on which the project started. Every piece of equipment, the chemist uses has a serial number and a cost. Model the above scenario in database managementarrow_forwardQuestion 1 A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (CIT 170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr