Fundamentals of Information Systems
9th Edition
ISBN: 9781337097536
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 1PSE
Program Plan Intro
- Develop a simple data model for a student
database .
- Determine data attributes that should be present in each table and identify primary key for each table.
- Make an ER diagram showing relation between these tables.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Develop 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.
Develop a simple data model for a student database that includes student data, 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 entity relationship diagram that shows how these tables are related to one another.
The processes used to complete a data science project vary in their number of steps and functions, but in the end, the objectives and outcomes are similar.
Research on the Web to identify what you believe to be the set (version) of steps that you'd use to complete a Data Science project. You should find versions with 5, 7, 9, 11, 12, or more steps. If you choose a particular set of steps, cite your source and explain why you would use that approach. If you wish, you can develop your own approach, drawing on the research, if you think there may be a better way. As you get deeper into Data Science, in subsequent courses, you should learn the validity of your approach.
List the steps of your approach, cite its source, and provide an explanation of why this particular approach would work best for you.
Chapter 3 Solutions
Fundamentals of Information Systems
Ch. 3 - Prob. 1LOCh. 3 - Prob. 2LOCh. 3 - Prob. 3LOCh. 3 - Prob. 4LOCh. 3 - Prob. 5LOCh. 3 - Define the role of the database schema, data...Ch. 3 - Prob. 7LOCh. 3 - Prob. 8LOCh. 3 - Prob. 9LOCh. 3 - Prob. 10LO
Ch. 3 - Prob. 11LOCh. 3 - Prob. 12LOCh. 3 - Prob. 13LOCh. 3 - Explain how a NoSOL database is different from an...Ch. 3 - Prob. 15LOCh. 3 - Prob. 16LOCh. 3 - Prob. 1.1RQCh. 3 - Which attribute would you designate as the primary...Ch. 3 - Prob. 1.1CTQCh. 3 - Prob. 1.2CTQCh. 3 - Prob. 2.1RQCh. 3 - Prob. 2.2RQCh. 3 - Prob. 2.1CTQCh. 3 - Prob. 2.2CTQCh. 3 - Prob. 3.1RQCh. 3 - Prob. 3.2RQCh. 3 - What additional questions need to be answered...Ch. 3 - Prob. 3.2CTQCh. 3 - Prob. 4.1RQCh. 3 - Prob. 4.2RQCh. 3 - Prob. 4.1CTQCh. 3 - Prob. 4.2CTQCh. 3 - Prob. 5.1RQCh. 3 - Prob. 5.2RQCh. 3 - Why is it unlikely that a traditional SQL database...Ch. 3 - Prob. 5.2CTQCh. 3 - Prob. 1SATCh. 3 - Prob. 2SATCh. 3 - Prob. 3SATCh. 3 - Prob. 4SATCh. 3 - The ability to combine two or more tables through...Ch. 3 - Prob. 6SATCh. 3 - Prob. 7SATCh. 3 - Prob. 8SATCh. 3 - Prob. 9SATCh. 3 - Prob. 10SATCh. 3 - Prob. 11SATCh. 3 - Prob. 12SATCh. 3 - Prob. 13SATCh. 3 - Prob. 14SATCh. 3 - Prob. 15SATCh. 3 - Prob. 16SATCh. 3 - Prob. 1RQCh. 3 - In the hierarchy of data, what is the difference...Ch. 3 - Prob. 3RQCh. 3 - What is meant by data archiving? Why is this an...Ch. 3 - What is an entity-relationship diagram, and what...Ch. 3 - Identify four basic data manipulations performed...Ch. 3 - Prob. 7RQCh. 3 - Prob. 8RQCh. 3 - Prob. 9RQCh. 3 - Prob. 10RQCh. 3 - Prob. 11RQCh. 3 - Prob. 12RQCh. 3 - Prob. 13RQCh. 3 - Prob. 14RQCh. 3 - Prob. 15RQCh. 3 - Prob. 16RQCh. 3 - Prob. 17RQCh. 3 - Prob. 1DQCh. 3 - Outline some specific steps an organization might...Ch. 3 - SQL databases conform to ACID properties. Briefly...Ch. 3 - Prob. 4DQCh. 3 - Prob. 5DQCh. 3 - Prob. 6DQCh. 3 - Prob. 7DQCh. 3 - Prob. 8DQCh. 3 - Prob. 9DQCh. 3 - Prob. 1PSECh. 3 - A company that provides a movie-streaming...Ch. 3 - Prob. 3PSECh. 3 - Prob. 4PSECh. 3 - Prob. 1WECh. 3 - Prob. 2WECh. 3 - Prob. 3WECh. 3 - Describe the role of a database administrator....Ch. 3 - Prob. 2CECh. 3 - Prob. 1.1CSCh. 3 - Prob. 1.2CSCh. 3 - Prob. 1.3CSCh. 3 - Prob. 2.1CSCh. 3 - Prob. 2.2CSCh. 3 - Prob. 2.3CS
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 hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?arrow_forwardThe management of major-related data is something your department is interested in. Create a data structure that will keep your department's important information current. Of course, the majors list needs to be arranged by last name (and then by first, if there are multiple students with the same last name).arrow_forwardWhat is the purpose of a data model, and how will it assist us in reaching our objective?arrow_forward
- What are the main differences between data items and data attributes in the data hierarchy? How does an attribute have scope?arrow_forwardWhat are the advantages of using the same data model for both conceptual and logical design over using two different models? For example, E-R and relational database models….arrow_forwardDo you have any recommendations for particular approaches that might be used to capture the flow of data?arrow_forward
- We would like to design a database to store information that is related to a charity agency, the database requirements are as follows: Information kept about each employee: Employee identification number (unique for each employee), username and password, name for each employee, date of birth, phone, and email. Information kept for each Donation: Donation identification number (unique for each donation), donation date, and donation type. Information kept for each donor: Donor identification number (unique for each donor), the donor name, the donor name stored separately (first name, second name, and last name), the donor address also stored separately (street number, street name, zip code, city), the phone, and the email. Information kept about each item donated: Item identification number (unique for each item), item name, and quantity. Information kept for each needed/supported family: Family name, number of members in the family, nationality, address, income, and phone…arrow_forwardExplain the concept of data redundancy and how it can be minimized in a well-designed data model.arrow_forwardTo begin, what are the key distinctions between developing a data model from scratch and using one that has already been pre-packaged?arrow_forward
- 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…arrow_forward"Mpho is very excited about the new information system to be built for his spaza shop. In this section, you need to make Mpho understand database concepts and how they will benefit his spaza shop." To make Mpho understand databases and database management system, use an infographic to list and explain the hierarchy of data. The infographic must be easy to read. The data hierarchy must be listed in the order of the smallest to the largest.arrow_forwardWhat are the most significant distinctions that can be made between a data item and a data attribute within the context of the data hierarchy? When it is stated that an attribute has scope, what exactly does that entail?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 Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning