Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?

Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?
You 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…
You 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.…
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?
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?
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?
Assume 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?
Your task is to develop a database, in order to keep information on all sales at a motorcycle dealership. The database will include information on motorcycles, salespeople, sales, and customers. We assume for simplicity that the dealership sells only new motorcycles and that all motorcycles are produced by the same manufacturer. Each kind of motorcycle is called a model, and it has a unique model number. For each model, you want to store also its name, engine size in cubic centimeters (cc) which is an integer number, and the date when this particular model was introduced. For each salesperson, you want to store their employee ID number, first name, middle initial, last name, and the date when the employee was hired. For each customer, you want to store a customer ID number, first name, middle initial, last name, address information (city, state, and zipcode), phone number (given in standard US format), and e‐mail address. Assume that you do not have a zip code table available. Each…
Consider the following information about a university database: ▪ Professors have an SSN, a name, an age, a rank, and a research specialty. ▪ Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. ▪ Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). ▪ Each project is managed by one professor (known as the project’s principal investigator). ▪ Each project is worked on by one or more professors (known as the project’s co-investigators). ▪ Professors can manage and/or work on multiple projects. ▪ Each project is worked on by one or more graduate students (known as the project’s research assistants). ▪ When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. ▪ Departments have a department number, a department…
Using the Crow’s Foot Diagrram technique, draw a database design for the attached database.
You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
In this example, we will pretend that the student table in the university database is indexed by StudentID (the primary key), Major, Age, MaritalStatus, and HomeZipCode (all secondary keys). Let's pretend a university needed a list of students from the 45462 zip code who are either above the age of 25, married, and majoring in MIS or computer science OR who are under the age of 25 and majoring in computer engineering. Is there a way to use indexes to restrict results to to those entries that fulfill this condition?