Using MIS, Student Value Edition Plus MyLab MIS with Pearson eText - Access Card Package (9th Edition)
9th Edition
ISBN: 9780134473987
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 5.1UYK
Program Plan Intro
E-R model:
- It is a tool for creating data model.
- It is used for developers to describe the content of data model by using two functions called entities and relationships.
Entity:
- It helps the user for tracking something in
database . - Example entities in student database system are Student, Grade, Course, etc.
Relationships:
- Entities have relationships among each other.
- For example, in student database, a Student has a relationship to Major and Student has a relationship to Advisor.
Attribute:
- It used to describe the entity characteristics.
- Example attributes of student entity is Student_id, Student_name, Student_address, etc.
Identifier:
- It is an attribute or group of attribute, but its value is related with one and only one entity instance.
Example of E-R diagram:
Expert Solution & Answer
Explanation of Solution
Entity Relationship diagram that displays relationship among the database, database application and users:
The below is the E-R diagram that shows the relationship that is laid among the database, database application and users:
User:
The person or end user that can process the application that is stored in the database.
Database application:
A database application is a collection of four elements namely forms, reports, queries and application which acts as an intermediate between the user and data of the database
Database:
Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.
Explanation of the E-R diagram:
- Many user can use the database application.
- Example of the user entity could be “students”, “faculty”.
- Many database applications can be present in a single database.
- Example of the database application could be “Bookstore”,”Library”.
- Only one database can contain many database application.
- Example of the database could be “studentDB”,”BookStoreDB”.
- The relationship between the user and the database application is “M:N (Many to many )relationship.
- The relationship between the database application and theDatbase is “N:1”(Many to One) relationship.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
8. Name and Email AddressesWrite a program that keeps names and email addresses in a dictionary as key-value pairs. The program should display a menu that lets the user look up a person’s email address, add a new name and email address, change an existing email address, and delete an existing name and email address. The program should pickle the dictionary and save it to a file when the user exits the program. Each time the program starts, it should retrieve the dictionary from the file and unpickle it.
How would the user be able to use the program?
Please solve and answer the question correctly please. Thank you!!
Please solve and answer the question correctly please. Thank you!!
Chapter 5 Solutions
Using MIS, Student Value Edition Plus MyLab MIS with Pearson eText - Access Card Package (9th Edition)
Ch. 5.2 - Prob. 1EGDQCh. 5.2 - Prob. 2EGDQCh. 5.2 - Prob. 3EGDQCh. 5.2 - Prob. 4EGDQCh. 5.2 - Prob. 5EGDQCh. 5.2 - Prob. 6EGDQCh. 5.2 - Prob. 7EGDQCh. 5.2 - Prob. 8EGDQCh. 5.3 - Prob. 1NWDSCh. 5.3 - Prob. 2NWDS
Ch. 5.3 - Prob. 3NWDSCh. 5.3 - Prob. 4NWDSCh. 5.3 - Prob. 5NWDSCh. 5.8 - Prob. 1SGDQCh. 5.8 - Prob. 2SGDQCh. 5.8 - Prob. 3SGDQCh. 5.8 - Prob. 4SGDQCh. 5.8 - Prob. 5SGDQCh. 5.8 - Prob. 6SGDQCh. 5.8 - Prob. 7SGDQCh. 5.8 - Prob. 1IKDMCh. 5.8 - Prob. 2IKDMCh. 5.8 - Prob. 3IKDMCh. 5.8 - Prob. 4IKDMCh. 5.8 - Prob. 1ARQCh. 5.8 - Prob. 2ARQCh. 5.8 - Prob. 3ARQCh. 5.8 - Prob. 4ARQCh. 5.8 - Prob. 5ARQCh. 5.8 - Prob. 6ARQCh. 5.8 - Prob. 7ARQCh. 5.8 - Prob. 8ARQCh. 5 - Prob. 5.1UYKCh. 5 - Prob. 5.2UYKCh. 5 - Prob. 5.3UYKCh. 5 - Prob. 5.4UYKCh. 5 - Prob. 5.5CE5Ch. 5 - Prob. 5.6CE5Ch. 5 - Prob. 5.7CE5Ch. 5 - Prob. 5.8CE5Ch. 5 - Prob. 5.9CE5Ch. 5 - Prob. 5.10CE5Ch. 5 - Prob. 5.11CE5Ch. 5 - Prob. 5.12CE5Ch. 5 - Prob. 5.13CS5Ch. 5 - Prob. 5.14CS5Ch. 5 - Prob. 5.15CS5Ch. 5 - Prob. 5.16CS5Ch. 5 - Prob. 5.17CS5Ch. 5 - Prob. 5.18CS5Ch. 5 - Prob. 5.19CS5Ch. 5 - Prob. 5.2MMLCh. 5 - Prob. 5.21MML
Knowledge Booster
Similar questions
- W AutoSave Off File Home Insert Draw Design Assignment_1[1] - Protected... ■ Saved V > Search Layout References Mailings Review View Help QuillBot RefWorks - RCM PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing PR Comments Viewing Share × 2. The following state transition table is a simplified model of process management, with the labels representing transitions between states of READY, RUN, BLOCKED, and NONRESIDENT. READY RUN BLOCKED NONRESIDENT READY RUN - 1 - 5 BLOCKED 2 4 3 - 6 Give an example of an event that can cause each of the above transitions. Draw a diagram if that helps. (5) Page 2 of 4 20 of 278 words Text Predictions: On 64 f W Focus + 170% ENG US 17:13 2025/03/24arrow_forwardI need help understanding how could I got the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnetarrow_forwardI need help understanding how could I got the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnetarrow_forward
- Please answer Java OOP homework scenario below: You have been hired by the National Insurance Company to create a program to track insurance policies for all its customers. National Insurance provides three types of insurance: automobile, home and life insurance. The program should be able to track up to 100 policies. Based on the provided information, create an efficient, object-oriented solution with good design principles that will allow a user to manage policies. To do this, the solution should have a menu with the following capabilities: Add Policy o This capability will allow a user to add a policy. The user should specify if the policy is for home, auto, or life. Once the type of policy has been selected, the user should be prompted for all required fields for the policy type. Remove Policy o This capability will allow a user to select any policy and remove it from the list. View policies o This capability will allow a user to see all the policies. All policy fields…arrow_forwardWhat are the two errors in my pseudocode?Module getAverage(Integer value1, Integer value2, Integer value3) Declare Integer average average = value1 + value2 + value3 / 3 Display average End Modulearrow_forwardWhere did I make an error in my pseudocode module???Code:Module main() Call raiseToPower(2, 1.5) End main Module raiseToPower(Real value, Integer power) Declare Real result Set result = value ^ power Display result End raiseToPowerarrow_forward
- Why does my pseudocode not perform what I asked? Don't know whats wrong with it.// This program asks the user to enter a value // between 1 and 10 and validates the input. Declare Integer value // Get a value from the user. Display "Enter a value between 1 and 10." Input value // Make sure the value is between 1 and 10. While value < 1 AND value > 10 Display "ERROR: The value must be between 1 and 10." Display "Enter a value between 1 and 10." Input value End Whilearrow_forwardWhat's wrong with my pseudocode? // The calcDiscountPrice function accepts an item’s price and // the discount percentage as arguments. It uses those // values to calculate and return the discounted price. Function Real calcDiscountPrice(Real price, Real percentage) // Calculate the discount. Declare Real discount = price * percentage // Subtract the discount from the price. Declare Real discountPrice = price – discount // Return the discount price. Return discount End Functionarrow_forwardNeed help converting my pseudocode to python, AND have a flowchart showing everything!The code: Function getScore() // Prompt the user to enter a test score Display "Enter a test score as a percentage (0-100): " Input score // Return the score entered by the user Return scoreEnd Function Function getGPAPoint(Integer score) // Determine GPA point based on the score If score >= 90 Then Return 4.0 Else If score >= 80 Then Return 3.0 Else If score >= 70 Then Return 2.0 Else If score >= 60 Then Return 1.0 Else Return 0.0 End IfEnd Function Function getAverage() // Initialize variables to store the sum of scores and GPA points totalScore = 0 totalGPA = 0.0 // Loop to collect 5 test scores For i = 1 to 5 Do score = getScore() // Call getScore function to get a test score totalScore = totalScore + score // Add score to totalScore gpaPoint = getGPAPoint(score) // Convert…arrow_forward
- Where did I make an error in my pseudocode module???Code:Module main() Call raiseToPower(2, 1.5) End main Module raiseToPower(Real value, Integer power) Declare Real result Set result = value ^ power Display result End raiseToPowerarrow_forwardI need help writing pseudocode for calculating class score average by putting in 5 test scores, and showing the average from all 5 inputs and the GPA score.Starting with 3 functions outside of a main module. The functions are getScore(), getGPAPoint(Integer score), and getAverage(). Function getscore is an input for a grade as a class percentage. Function getGPAPoint will calculate the score into a GPA point and return as a float (values of 90-100 as 4.0, 80-89 as 3.0, 70-79 as 2.0, 60-69 as 1.0, and anything below 60 as 0.) Function averageGPA will finally make a call to both previous functions when the user inputs numbers 5 times that then calculates the average (add up all the scores, divide by 5) and the average grade alongside displaying the average GPA. End result is a main module that makes a proper call to the averageGPA function and display its results. Need help with this!arrow_forwardPlease original work Why is integration between data collection and business analysis so important to success in an organization that uses business analytics? How can a company that is just starting to use business analytics set up its program for success right from the beginning? Please cite in text references and add weblinksarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education