Exercise 3-1. Consider the scenario described at the beginning of this chapter: When parents call to say that children are sick, we have to let their classroom teachers know, and if it's sports day and the child is on a school team, the sports teacher might have to sort out substitutes. Then we need to count up all the days missed to put on the child's report. The Department of Education needs the totals each term, too. Run through the steps in the summary section and sketch some use cases and an initial data model. Assume that the main objectives are to record the absences for the classroom teacher, for school reports, and for statistics given to the Department of Education.

Exercise 3-1. Consider the scenario described at the beginning of this chapter: When parents call to say that children are sick, we have to let their classroom teachers know, and if it's sports day and the child is on a school team, the sports teacher might have to sort out substitutes. Then we need to count up all the days missed to put on the child's report. The Department of Education needs the totals each term, too. Run through the steps in the summary section and sketch some use cases and an initial data model. Assume that the main objectives are to record the absences for the classroom teacher, for school reports, and for statistics given to the Department of Education.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Consider the following preference profile P: Applicant Preferences Hospital Preferences H4 H2 H3 H3…

Q: If the collision happens again that k =1 (Note: Consider the value of k = when the collision…

A: The current scenario here is to find the probability of collision, when the collision happened at…

Q: at deals with the additional tax, Kindly note that based on the case background it also stated that…

A: The system software used to create and administer databases is called a database management system…

Q: In a hospital setting, a patient is assigned a patient id and we need to keep track of patient’s…

A: Required Schema Pateient (ID, name, gender, DOB, address) StaffMember(ID, title, gender, name,…

Q: You just started your summer internship with immunityPlus based in La Crosse, Wisconsin. You are…

A: I give the code in Python along with the output and code screenshots

Q: 2.2 Use case 2: A consumer organization tested two paper shredders, the Piranha and the Crocodile,…

A: Ther

Q: Suppose, as manager of a chain of stores, you would like to use sales transactional data to analyze…

A: Today discovery of the new items comes with huge profit deals when it comes from the high utility…

Q: What is the best way to decide how many epochs of training to perform? It is always obvious looking…

A: Epoch meaning:- An epoch is a term used in machine learning and indicates the number of passes of…

Q: [For this question, you can use a program such as Excel or Word (paste into the quiz, then format at…

A: The given information is a factorial matrix that shows the combinations of two variables: "THIS" and…

Q: A hospital is a very busy place with a lot of patients and a lot of employees. All people in the…

A: 1. Define the base class Person: - Initialize attributes: name, gender, address, email,…

Q: Retail Price Regular Unleaded 1.55 You are interested in looking at how competition affects gas…

A: In our study, we seek to delve into the intricate relationship between competition and gas prices,…

Q: The only way to tell if a model is right or wrong is to see how well it works on test data. tell me…

A: Evaluating the performance of a model is a crucial step in data analysis. It allows us to determine…

Q: Damon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income…

A: Introduction: Accounting worksheet: The accounting worksheet comprises columns for the unadjusted…

Q: Let's say you're interested in learning whether or not Facebook users with more "likes" also have…

A: To investigate whether Facebook users with more "likes" also have more Facebook friends, I would use…

Q: Only by seeing how well a model performs on test data can its accuracy be determined. elaborate on;…

A: Introduction: The typical procedure for assessing machine learning models is to fit and evaluate…

Q: Hi There! I need help with this simulation model problem. I get how to do a basic coin toss using…

A: In this question, we have to create a simulation model problem related to a game show scenario with…

Q: Utilizing a decision table makes things lot simpler when it comes to associating conditions with…

A: 1) A decision table is a systematic and visual representation of various conditions and…

Q: Exercise 3-1. Consider the scenario described at the beginning of this chapter: When parents call to…

A: Answer : Now ERP system will solve the problem completely and even offer more feature for staffs…

Q: OA Mathematics 110 class at a junior college must select 3 students to serve on an advisory…

A: the solution is an given below :

Q: Only by seeing how well a model performs on test data can its accuracy be determined. elaborate on;…

A: HI THEREI AM ADDING ASNWER BELOWPLEASE GO THROUGH ITTHANK YOU

Q: Consider the following scenario: you've been tasked with developing a logical model of a school or…

A: Introduction: Justification: A top-down or bottom-up approach is preferable to build a logical model…

Question

TESTING YOUR UNDERSTANDING
Exercise 3-1.
Consider the scenario described at the beginning of this chapter:
When parents call to say that children are sick, we have to let their classroom teachers know, and if it's
sports day and the child is on a school team, the sports teacher might have to sort out substitutes. Then
we need to count up all the days missed to put on the child's report. The Department of Education needs
the totals each term, too.
Run through the steps in the summary section and sketch some use cases and an initial data model. Assume
that the main objectives are to record the absences for the classroom teacher, for school reports, and for
statistics given to the Department of Education.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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

Please explain plain as possible [For this question, you can use a program such as Excel or Word (paste into the quiz, then format at needed), or use the table formatting tools in the Canvas Toolbar in the quiz question to create your matrix.] Using the scenario information, illustrate a factorial matrix with identifiers for each side of the matrix, and the variable identifications in each box of the table. The goal is that your reader should be able to visually see what you are researching based on the matrix table. Do not copy and paste the matrix from SPSS or other automatically generated format. You are to create the table manually. However, it does not need to be complicated. Simply identify a letter or code that illustrates your variables in the scenario, and be sure your reader knows what they mean. An example is provided below. The goal here is not that you produce a beautifully formatted table for this quiz, but that your information is clearly understandable to your…
In Chapter 3 of Sharma et al. (2010), you will be introduced with a case study: "This case study describes a simple Library Management System. Assume the requirements for the system were written by your client exactly in these terms: The system will manage the author's and loaner's information, and keep track of books loaned. The borrower's information includes name, address, e-mail, and phone. The author's information includes name, address, and e-mail. New books, authors and clients are entered into the system. When a client checks out a book, the system will register the date the book was loaned and calculate the days the book can be loaned. It will also calculate the date the book is due to be returned. If the borrower returns the book late, he must pay a fine based on the number of days overdue." (Sharma, et al., 77). Assume that the traditional file system is currently used in this library and a DBMS is to be developed. Discuss the advantages and challenges for the use of…
A school wants to develop an automatic marking system that can automatically generate test papers from the question bank and automatically correct them. For this system, draw a Stakeholder Map Matrix.
Can you tell me if there is any mistakes in this diagram?? thats its requirenments: During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC’s manager gives you the following description of the business: TEC has a file of candidates who are willing to work. If the candidate has worked before, that candidate has a specific job history. (Naturally, no job history exists if the candidate has never worked.) Each time the candidate works, one additional job history record is created. Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. (For example, it is possible for more than one candidate to have earned a BBA degree or a Microsoft Network Certification. And clearly, a candidate may have earned both a BBA and a Microsoft Network Certification.) TEC offers courses to help candidates improve their qualifications. Every course develops one specific qualification; however, TEC does not…
A decision table is a useful tool for quickly and easily associating circumstances with responses. Explain?
Suppose, as manager of a chain of stores, you would like to use sales transactional data to analyze the effectiveness of your store's advertisements: In particular, you would like to study how specific factors influence the effectiveness of advertisements that announce a particular category of items on sale. The factors to study are: the region in which customers live, and the day-of-the-week, and time-of-the-day of the ads. Discuss how to design an efficient method to mine the transaction data sets and explain how multidimensional and multilevel mining methods can help you derive a good solution.
Fact-Finding Summary• A typical center has 300–500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded on acharge slip, which is signed by the member.• At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receiptsare deposited in a local bank and credited to the corporate Personal Trainer account. TheBumbleBee program produces a daily activity report with a listing of all sales transactions.• At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member statements are prepared and mailed. Members mail their payments to…
A program called lsu [104] gives access to role accounts. The user's access rights are checked, and the user is required to enter her password. If access rules allow the change and the user's password is correct, lsu allows the change. Given that Mary uses lsu from her account, why does lsu require her to enter her password? Name the principles involved, and why they require this
A number of parents have volunteered their children to participate in a developmental study administered by a local child psychologist. The following chart summarizes the results of the psychologist's assessments. Developmental Test Scores 40- 35 30 25 20 15 10 1 2 4 5 6 7 8 9 10 Age (years) Which of the following statistical techniques can the psychologist use to determine the developmental score of a typical 4-year- old child despite the fact that no 4-year- old children participated in the study? O Regression O Clustering Classification O Outlier/anomaly detection Score on Developmental Test
Suppose you wish to study the relationship between the number of 'likes' on Facebook and the number of 'friends' one has on Facebook. Describe the statistical technique you would use.
The default cutoff value in the two-class classifier (i.e., C1/C2) is 0.5. Thus, if the probability of a record being a class C1 member is greater than 0.5, that record is classified as C1. It is possible to use a cutoff that is greater or lower than 0.5. In general, lowering the cutoff value will result in a decrease (no change) in the classification error rate for records that are truly C1. Note that is not an overall error rate. True False
Create an ER model to represent the data used by the library.The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.