Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 1, Problem 1.42PAE
In this chapter, we described four important data models and their properties: enterprise, conceptual, logical, and physical. In the following table, summarize the important properties of these data models by entering a Y (for yes) or an N (for no) in each cell of the table.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Please draw the ER diagram. Explain how you know which one is entity, attribute, and all constraints. Explain each step of the diagram.
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database.
StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database.
StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
Chapter 1 Solutions
Modern Database Management (12th Edition)
Ch. 1 - Prob. 1.1RQCh. 1 - Match the following terms and definitions:...Ch. 1 - Prob. 1.3RQCh. 1 - Prob. 1.4RQCh. 1 - Prob. 1.5RQCh. 1 - How are relationships between tables expressed in...Ch. 1 - What does the term data independence mean, and why...Ch. 1 - Prob. 1.8RQCh. 1 - Prob. 1.9RQCh. 1 - Prob. 1.10RQ
Ch. 1 - Prob. 1.11RQCh. 1 - Prob. 1.12RQCh. 1 - Prob. 1.13RQCh. 1 - Prob. 1.14RQCh. 1 - Prob. 1.15RQCh. 1 - Prob. 1.16RQCh. 1 - Prob. 1.17RQCh. 1 - Prob. 1.18RQCh. 1 - Prob. 1.19RQCh. 1 - Prob. 1.20PAECh. 1 - Prob. 1.21PAECh. 1 - Prob. 1.22PAECh. 1 - Prob. 1.23PAECh. 1 - Prob. 1.24PAECh. 1 - Prob. 1.25PAECh. 1 - Great Lakes Insurance would like to implement a...Ch. 1 - Prob. 1.27PAECh. 1 - Prob. 1.28PAECh. 1 - Prob. 1.29PAECh. 1 - Prob. 1.30PAECh. 1 - Prob. 1.31PAECh. 1 - Prob. 1.32PAECh. 1 - Prob. 1.33PAECh. 1 - Prob. 1.34PAECh. 1 - Prob. 1.35PAECh. 1 - Prob. 1.36PAECh. 1 - Prob. 1.37PAECh. 1 - Consider the project data model shown in Figure...Ch. 1 - Prob. 1.39PAECh. 1 - Prob. 1.40PAECh. 1 - Helen Jarvis wants to determine the most important...Ch. 1 - In this chapter, we described four important data...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Give a Java statement that will display a dialog window on the screen with the message I Love You.
Java: An Introduction to Problem Solving and Programming (8th Edition)
The job of the _____ is to fetch instructions, carry out the operations commanded by the instructions, and prod...
Starting Out With Visual Basic (8th Edition)
A magic number is _______. a. a number that is mathematically undefined b. an unexplained value that appears in...
Starting Out with Python (4th Edition)
Suppose that we create an array A of GameEntry objects, which has an integer scores field, and we clone A and s...
Data Structures and Algorithms in Java
A dataset has 1000 records and 50 variables with 5% of the values missing, spread randomly throughout the recor...
Data Mining for Business Analytics: Concepts, Techniques, and Applications with XLMiner
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
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardTherefore, why isn't an object's presence in a data model required?arrow_forwardThe following is a list of entries with level numbers in a file of employee records: 1 Employee(200) 2 SSN(Social Security Number) 2 Name 3 Last 3 First 3 Middle Intial 2 Address 3 Street 3 Area 4 City 4 State 4 ZIP 2 Age 2 Salary 2 Dependents a) Draw the corresponding hierarchical structure. b) Which of the items are elementary items? c) Considering the above phenomenon of if we want to keep the information of Employee (200) name and their performance grade categorized as (A, B, C, F) using pointer arrays. What do you think which representation approach of pointer array will be more appropriate if we want to categorize employees according to performance grade quickly. Draw and justify you representation.arrow_forward
- How do you model inheritance or specialization in a data model, and what are the common approaches?arrow_forwardSuppose you are given a data set that classifies each sample unit into one of four categories: A, B, C, or D. You plan to create a computer database consisting of these data, and you decide to code the data as A = 1, B = 2, C = 3, and D = 4. Are the data consisting of the classifications A, B, C, and D qualitative or quantitative? After the data are input as 1, 2, 3, or 4, are they qualitative or quantitative?arrow_forwardER modeling is one approach in creating a data model. There are several approaches in creating a data model (bottom up, top down, inside out, and mix). 1. explain each of these approaches!2. Then explain when we use top down, bottom up, inside out and mix? what is the function of each of the approaches?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY