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
Question
Chapter 2, Problem 2.39PAE
Program Plan Intro
(a) Draw an ERD for the given situation.
Program Plan Intro
(b) Draw an ERD for the given situation:
Program Plan Intro
(c) Draw an ERD for the given situation. Answer the ways in which you model SECTION and the reason for which you choose this way versus alternative ways to model SECTION.
Program Plan Intro
(d) Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time.
Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.
Program Plan Intro
(e) Draw an ERD for the following situation. Make assumption that credit results may not be reused for multiple credit requests and redraw the ERD for this new situation using two entity types, and then redraw it again using one entity type. Name the versions do you prefer among the two and provide reason for same.
Program Plan Intro
(f) Draw an ERD for the given situation and provide the reason for which these different changes to the situation led to different data models, if they did.
Program Plan Intro
(g) Draw an ERD for the given situation.
Program Plan Intro
(h) Draw an ERD for the given situation:
Program Plan Intro
(i) Draw an ERD for the given situation.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
7. Long-Distance CallsA long-distance provider charges the following rates for telephone calls:
Rate Category Rate per MinuteDaytime (6:00 a.m. through 5:59 p.m.) $0.07Evening (6:00 p.m. through 11:59 p.m.) $0.12Off-Peak (midnight through 5:59 a.m.) $0.05Write a GUI application that allows the user to select a rate category (from a set of radio buttons), and enter the number of minutes of the call into an Entry widget. An info dialog box should display the charge for the call.
Name and Address
The Name and Address Problem
Write a GUI program that displays your name and address when a button is clicked. The program’s window should appear as the sketch on the left side of Figure 13-61 when it runs. When the user clicks the Show Info button, the program should display your name and address, as shown in the sketch on the right of the figure.
Exercise 1 Function and Structure [30 pts]
Please debug the following program and answer the following questions. There is a cycle in a linked
list if some node in the list can be reached again by continuously following the next pointer.
#include
typedef struct node {
int value;
struct node *next;
} node;
int 11_has_cycle (node *first)
if (first
==
node *head =
{
NULL) return 0;
first;
while (head->next != NULL) {
}
if (head
first) {
return 1; }
head = head->next;
return 0;
void test ll_has_cycle () {
int i;
node nodes [6];
for (i = 0; i < 6; i++) {
nodes [i] .next = NULL;
nodes [i].value = i;
}
nodes [0] .next
=
&nodes [1];
nodes [1] .next
=
&nodes [2];
nodes [2] .next
=
&nodes [3];
nodes [3] .next
nodes [4] .next
&nodes [4];
NULL;
nodes [5] .next = &nodes [0];
printf("1. Checking first list for cycles. \n Function 11_has_cycle says it
has s cycle\n\n", 11_has_cycle (&nodes [0])?"a":"no");
printf("2. Checking length-zero list for cycles. \n Function 11_has_cycle
says it has %s…
Chapter 2 Solutions
Modern Database Management (12th Edition)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQCh. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Prob. 2.12RQCh. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - For each of the descriptions below, perform the...Ch. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - The entity type STUDENT has the following...Ch. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Prob. 2.35PAECh. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
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
- how to read log logsarrow_forwardDiscrete Mathematics for Computer Engineeringarrow_forwardQuestion 1 - Array Iterators Like the JS on A2, there is no visual component to this question. The HTML really just needs to load the JavaScript, everything else will output to the console. The JS file should the completion of the task, and all necessary testing, so that just loading the file will complete the task with enough different inputs to ensure it works. Even Numbers [3 marks] Create a function that determines if a provided number is even. Define an array of numbers, then on the array use the appropriate array iterator to determine if the array contains only even numbers using the function you defined. Output the results, and test with several arrays. Long Names [3 marks] Define an array of names. Use an iterator to retrieve a new array containing only the names longer then 12 characters. Your iterator should be passed an anonymous arrow function. Test with several different arrays First Names [3 marks] Define an array called fullNames that contains 7 javascript objects of…arrow_forward
- Discrete Mathematics for Computer Engineeringarrow_forwardthis module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks ) this is question 3: Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…arrow_forwardthis module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks ) this is question 3: Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…arrow_forward
- this module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks ) this is question 3: Question3: (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…arrow_forwardDiscrete Mathematics for Computer Engineeringarrow_forwardTask 1: Write an abstract class Method +: public -: private #: protected Underline: static # input: int # output:String Method + isHard():boolean + specificWay():String + Method() + Method(input: int, output: String) + getInput(): int + setInput(input: int): void + getOutput(): String + setOutput(output: String): void +toString(): String Question Task 2: Write a class ReadMethod that extends the Method class. +: public -: private #: protected Underline: static -language: String ReadMethod Question + ReadMethod() + ReadMethod(input: int, output: String, language: String) + isHard():boolean + specific Way(): String +toString(): String + getLanguage(): String + setLanguage(language: String): voidarrow_forward
- i have attatched my java question , please make sure it is answered correct, include all comments etc, thank youarrow_forwardi have attached my 2 java questions . please answer them correctly, add all comments etc . thank you.arrow_forwardCan you help me solve this problem using Master's Theorem:Solve the recurrence relation f(n) = 3af(n/a) + (n + a)2 with f(1) = 1 and a > 1 byfinding an expression for f(n) in big-Oh notation.arrow_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