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
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.
The 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).
What is the purpose of a data model, and how will it assist us in reaching our objective?
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_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_forwardExplain the concept of data redundancy and how it can be minimized in a well-designed data model.arrow_forward
- To begin, what are the key distinctions between developing a data model from scratch and using one that has already been pre-packaged?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_forwardWhat are the benefits of utilizing the same data model for both conceptual and logical design as opposed to having two distinct models for each? E-R and relational database models, for instance...arrow_forward
- What are the main differences between a data item and a data attribute in terms of the data hierarchy? What does it mean for an attribute to have a scope?arrow_forwardData independence is an essential objective, but what does it imply exactly?arrow_forwardWhich are the objectives that are sought with derived data are quite different from the objectives of reconciled data?arrow_forward
- How much is data modeling used in the analytical process? Is there a method to estimate how much data our model will require?arrow_forwardWhy is it important to differentiate between derived and stored attributes in data modeling?arrow_forwardIt's important to know what a data model is and what it does.It's important to know what conceptual modelling is and how it works so that you can use it. For conceptual modelling, what are the rules?DBMS systems are used to keep track of information. Describe how they are used.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