Principles of Information Systems (MindTap Course List)
12th Edition
ISBN: 9781285867168
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 5, Problem 2CTQ2
Program Plan Intro
Given scenario:
The university
Explanation of Solution
People have access to only one row:
“Students” can access their own details in a row in the tables of academic data, contact data, medical data and financial data.
People have access to more than one row but not all rows:
“Head of the Department (HOD)”, “Professor...
Explanation of Solution
People have access to all rows but cannot modify the data:
The principal of university may access all rows of th...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Define the term "data normalization" and its significance in database design.
Why is data categorization and classification important within a data dictionary?
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
Chapter 5 Solutions
Principles of Information Systems (MindTap Course List)
Ch. 5.6 - Prob. 1DQCh. 5.6 - Prob. 2DQCh. 5.6 - Prob. 1CTQCh. 5.6 - Prob. 2CTQCh. 5.7 - Prob. 1DQCh. 5.7 - Prob. 2DQCh. 5.7 - Prob. 1CTQCh. 5.7 - Prob. 2CTQCh. 5 - Prob. 1SATCh. 5 - Prob. 2SAT
Ch. 5 - Prob. 3SATCh. 5 - Prob. 4SATCh. 5 - Prob. 5SATCh. 5 - Prob. 6SATCh. 5 - Prob. 7SATCh. 5 - Prob. 8SATCh. 5 - ______ is a special-purpose programming language...Ch. 5 - Prob. 10SATCh. 5 - Prob. 11SATCh. 5 - Prob. 12SATCh. 5 - Prob. 13SATCh. 5 - Prob. 14SATCh. 5 - An in-memory database (IMDB) is a database...Ch. 5 - Prob. 16SATCh. 5 - Prob. 17SATCh. 5 - Prob. 18SATCh. 5 - Prob. 19SATCh. 5 - Prob. 20SATCh. 5 - Prob. 1RQCh. 5 - What is the difference between a data attribute...Ch. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQCh. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - Prob. 14RQCh. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - Prob. 17RQCh. 5 - Prob. 18RQCh. 5 - What is data mining? What is OLAP? How are they...Ch. 5 - Prob. 20RQCh. 5 - Prob. 21RQCh. 5 - Prob. 1DQCh. 5 - Outline some specific steps an organization might...Ch. 5 - Briefly describe the ACID properties to which an...Ch. 5 - Prob. 4DQCh. 5 - Prob. 5DQCh. 5 - Prob. 6DQCh. 5 - Prob. 7DQCh. 5 - Prob. 8DQCh. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Prob. 11DQCh. 5 - Prob. 12DQCh. 5 - Prob. 13DQCh. 5 - Prob. 1PSECh. 5 - An online video movie rental store is using a...Ch. 5 - Using a graphics program, develop an...Ch. 5 - Prob. 1WECh. 5 - Prob. 1CECh. 5 - Prob. 2CECh. 5 - Prob. 1DQ1Ch. 5 - Prob. 2DQ1Ch. 5 - Prob. 1CTQ1Ch. 5 - Prob. 2CTQ1Ch. 5 - Prob. 1DQ2Ch. 5 - Prob. 2DQ2Ch. 5 - Prob. 1CTQ2Ch. 5 - Prob. 2CTQ2Ch. 5 - Prob. 1DQ3Ch. 5 - Prob. 2DQ3Ch. 5 - Prob. 1CTQ3Ch. 5 - Prob. 2CTQ3
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- In the process of designing databases, are you able to explain why a data model is required?arrow_forwardA 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…arrow_forwardNOTE: please explain better . Question 4 You have just been hired as a consultant for a big Health Care provider. Impressed by your background in databases, they want you to completely redesign their database system. Talking with the people at the HC provider, you get the following information (be very careful on some of these attributes, and apply everything you have learned to this point: - The database contains information about patients, hospitals and doctors. - Each patient has an ID, first name, last name, address and age. A patient is uniquely identified by his or her ID. - Each hospital has an id, name and budget. The id uniquely identifies a hospital. - Each doctor an id, a full name, email address and a favorite movie. The id uniquely identifies a doctor. - Each patient can be treated at many hospitals, a hospital can treat many patients. - Each doctor can work at only one hospital. A hospital can have many doctors. 4.1) Draw the…arrow_forward
- What is the influence of the data dictionary on the six phases of the Database Life Cycle (DBLC)?arrow_forwardHow are data models used for database development?arrow_forwardA Professor wants a database for his new University that will maintain data for the following entities with their attributes: a. Courses: title, credits, syllabus and prerequisites b. Course offered: course ID, year, semester, section number, instructor(s), timings and classroom. c. Students: student_ID, name and program d. Instructors: Instructors_ID, name, department and title They require a proper model to help with the enrolment of students into courses and rightfully graded after the course is rolled out. Construct an E-R diagram for the professor's University. Indicate all Primary keys, relationships and constraints. Document all assumptions that you make about the mapping constraints.arrow_forward
- How are relationships between entities represented in the relational data model?arrow_forwardExplain the concept of structured data and its importance in handling complex data types. How does structured data differ from unstructured data in a database?arrow_forwardDevelop a simple data model for a student database that includes student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete ER diagram that shows how these tables are related to on another.arrow_forward
- Data standardization usually focuses on fixing _ of data while data cleaning usually focuses on fixing _ of data. A- The entity; data dictionary B- The attribute; the entity C- The entity; the attribute D- Data dictionary; the entityarrow_forwardPick and summarise ONE (1) article that uses data classification in a variety of domains. (The summary should concentrate on how the material applies to data classification analysis specifically.) Please respond to the following questions: i. What is the problem or question(s) that this study is addressing? You should be able to locate the focal point. If there are any other issues, make a note of them as well. ii. What is the data's source? There are two or more sources of data in some studies. Give a brief description of how the data was obtained.arrow_forwardIn what ways does the Database Approach control the quality of the data?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY