Name the group of people who can access only one row, groups of people who can access more than one row but not all, people who have access to one row and people who can see data but not change it.

Question

Want to see the full answer?

Answer 1

Question

Chapter 3, Problem 2.2aCS

Program Plan Intro

Name the group of people who can access only one row, groups of people who can access more than one row but not all, people who have access to one row and people who can see data but not change it.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Define the term "data normalization" and its significance in database design.

A university wants to set up a database to record details about its staff, the departments they belong to and the training they attended. The purpose of developing the database is keep the staff information such as staff identity number, staff name, staff address, staff telephone number, staff job title and staff salary. As for the staff telephone number, the database allows keeping more than one of the staff telephone numbers. For the department information, the database keeps the name of the department and its location. It is required that every staff belongs to at least one department. Also, it is required that each department has exactly one staff to lead the department. To improve staff self-development, the university encourages every staff to attend courses. Hence, the database keeps the course information such as the course name, course duration, and course cost. Each staff is required to attend at least one course. For one course, the university can approve a number of staff…

A learning company wants to set up its database. They are trying to keep track of the following: student ID, name, grade level, the subject they need help in, and their contact and payment information. They also want to keep track of the teacher’ information such as their ID, name, subject matter expertise, and times available and rate. They will like to keep track of which student is assigned to which teacher and their meeting schedule as well. Question 1: List all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table Question 2: Use the normalization technique and form the 3NF tables