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

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…
1 Suppose you are a manager of an event management company. Your team is responsible for running various events. Each event, depending on its nature, runs for varied lengths. Your company policy is such that you charge a flat amount for each event your team is managing (irrespective of the duration a particular event). The size of the team that you are running is such that your team can manage to run one event at a particular time i.e. your company is unable to run multiple events at a particular time. More formally, if there are two events i and j, the events are mutually compatible (i.e. you can select both i and j) if s>f, or s,>f, where s, and f, are the start and finish time of the event i. You are required to select events that your team is going to manage so that you can maximize the profit for your company. The following table shows some candidate events for your company to manage for a particular day. Find out which events would you select such that you can maximize the profit…
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…
Solve the problem using STEPWISE Method. Remember to use the step by step procedures (Step 1-7)
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.
MAKE AN ER DIAGRAM FOR THE FOLLOWING PROMPT: Various physicians are working for a clinic and these doctors are identified by their respective employee numbers. The other descriptors of a doctor are: name, gender, address, and phone. Each physician’s specialty and rank are captured. Every physician serves as a primary care physician for at least one patient; however, no more than 20 patients are allotted to a physician. Every patient is assigned one physician for primary care. Data for patients include: patient number (the unique identifier of a patient), name, gender, date of birth, blood type and the code and name of allergies, if any. Physicians may prescribe medications to patients; thus, it is necessary to capture which physician(s) prescribe(s)s what medication(s) to which patient(s) along with dosage and frequency. In addition, no two physicians can prescribe the same medication to the same patient. If a physician leaves the clinic, all prescriptions written by that physician…
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…
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.
excel thanks
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.
A decision table is a useful tool for quickly and easily associating circumstances with responses. Explain?
When evaluating the correctness of a model, the only thing that can be considered is how well the model performs on test data. explain in detail, expand on? Explain?