Q2. Consider the following case study: "Springfield University offers a number of courses. A course contains a number of units. Students enrol and elect a set of units every semester. Students are allowed to enrol in a maximum of 5 units in any given semester. They can only be enrolled into a single course at any given point in time. However over a student's lifetime, they may undertake a number of different courses. Each unit has a set fee that is set at the start of the semester. This fee is to be paid up-front in full by the students once enrolled. Some units have pre-requisite unit requirements. Some units have co-requisite unit requirements. To be enrolled in some courses, you must have completed a certain course (e.g. to enrol into a Postgraduate course, you must have an Undergraduate degree)." Noun (bold)/verb (underline) analysis on the case study is marked for you to identify candidate classes, attributes, operations. Now, draw a Specification level Class Diagram for the case study.

Q2. Consider the following case study: "Springfield University offers a number of courses. A course contains a number of units. Students enrol and elect a set of units every semester. Students are allowed to enrol in a maximum of 5 units in any given semester. They can only be enrolled into a single course at any given point in time. However over a student's lifetime, they may undertake a number of different courses. Each unit has a set fee that is set at the start of the semester. This fee is to be paid up-front in full by the students once enrolled. Some units have pre-requisite unit requirements. Some units have co-requisite unit requirements. To be enrolled in some courses, you must have completed a certain course (e.g. to enrol into a Postgraduate course, you must have an Undergraduate degree)." Noun (bold)/verb (underline) analysis on the case study is marked for you to identify candidate classes, attributes, operations. Now, draw a Specification level Class Diagram for the case study.

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

FIRST QUESTION : An embassy records details of interviews of visa applicants in the table below. Interviews are conducted by members of staff in some of the embassy rooms. In any given day, a member of staff tends to use the same room throughout that day. An applicant cannot have two interviews in the same day : R : applicantNo interviewDate interviewTime staffNo roomNo AP1 13.5.2016 10:30 S5 R101 AP2 13.5.2016 12:00 S5 R101 AP3 13.5.2016 12:00 S9 R200 AP2 22.9.2016 10:30 S5 R200 - List all possible candidate keys for the above relation :
Students: Johnson, Williams, Matt, Jones, Eric, Lili, John and Jason, whose grades are listed below. Each column is the grades each student received. There are 8 students with 10 grades each. Johnson: 79, 92, 85, 0, 100, 64, 72, 99, 90, 86 Williams: 80, 75 93, 94, 0, 90, 89, 88, 87, 86 Matt: 82, 67, 72, 74, 89, 0, 70, 89, 100, 76 Jones: 85, 84, 82.5, 82, 84, 80, 80.5, 90, 96, 85 Eric: 90, 91, 87, 85.5, 86.5, 0, 90, 90, 91, 92 Lili: 60, 75, 81, 70, 80, 81, 94, 67.5, 99, 98 John: 79,0, 74, 96, 88.5, 88, 0, 100, 86, 83 Jason: 89, 90, 90, 85, 85, 90, 91, 88, 100, 79 Write user-defined functions or build-in functions (e.g., sum, mean, max, min, etc.) to calculate: The Average Grade of each student; this average should be a vector. The average of the class; this average is a scalar vector. The highest grade among the Average Grade of Each Student The lowest grade among the Average Grade of Each Student Show a table with each student's name, average grade and letter score using A, B, C, D, F…
1) Holiday Inn hires you to examine three hotel locations that can each use some updating. They have $4 million available for the updates. The future revenue projected for each hotel is tied to how much renovation is done, according to the following table: Renovation Amount Future Revenue (in millions) (in millions) $0 $1 $2 $3 Hotel A Hotel B Hotel C $4 $7 $8 $9 $3 $6 $10 $12 $14 $3 $7 $8 $13 $4 $11 $15 Use dynamic programming to determine how to best allocate the $4 million in renovations between the three hotels (assume you can only use $1 million increments).
Hello, Just want to check if the attached Crow's Foot ERD is correct for the following problem: Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all primary keys, foreign keys, and main attributes. Business rules are defined as follows: A large university consists of several schools. Each school is chaired by one employee. An employee may be the dean of one and only one school.
QUESTION 8 From the list below choose domains for which the given statement is true. "Everyone is studying discrete mathematics" Choose ALL that applies. O All people enrolled in MAT231 classes at the LAGCC. All people in the world O All students of the Computer Science program at LaGuardia O All students of New York City O All students of LaGuardia O All students in this class
a. Consider the following UML diagram. Author 1..2 1..3 Book 1..5 name title 0..4 Reader name (a) If there are 6 authors, what's the minimum and maximum number of books? What's the minimum and maximum number of readers? (b) If there are 6 readers, what's the minimum and maximum number of books? What's the minimum and maximum number of authors?
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
The stand rental system is going to be used by any company to search for stands, either by prices, by prices, or by types. If there is any interest then the company will request a quotation through the system. This request will be assessed by a salesman of INSIGHTS. The salesman will issue a quotation accordingly. In the case the prices are convenient, the company will reserve the stands that it is interested in. The company has three days to pay the costs of the stands. The costs are obtained from the invoice generated by the salesman. The company can cancel its reservation any time. Furthermore, before the starting of the event, an employee of INSIGHTS with the role of supervisor will generate a report about the companies that paid the fees and the current setup of the exhibition. The supervisor will also issue the necessary reminders to the companies to bring their equipment as well as bring their promotion documents to the site of the exhibition. In order to implement the expected…
Convert this plain text to ER diagram : "Each office employs one or more dentists, hygienists, andreceptionists each of whom have an employee number. Patientsare free to use any dental office but, naturally, must makeappointments in advance. A record of all such appointments iskept which specifies the patient’s name, the date and time ofthe appointment and a list of services performed. Adultpatients have a SIN (Social Insurance Number) but theirchildren typically do not. Each office provides specific services(e.g. cleaning, filling, X-rays, extraction, etc.) to the patients andbills them accordingly. Performing certain services consumessupplies (e.g. floss, amalgam, X-ray film, etc.). Such suppliesare purchased from a variety of suppliers each of whom isidentifiable by a unique supplier code. The current amount ofeach type of supply available is tracked so that when suppliesrun low, a new order may be placed with the appropriatesupplier. Patients are allowed to run accounts but…
There have been several actors who have played the titular character in the British sci-fi series Doctor Who since the show began in the early 1960s. In 2005 the series was rebooted and Christopher Eccleston, David Tennant, Matt Smith, Peter Capaldi, and Jodie Whittaker have all played the Doctor since. Several Whovians (fans of the show) were asked to rank the actors of the Doctor from their favorite to their least favorite. The results are in the preference schedule below using the initials of each actor (so CE = Christopher Eccleston; DT = David Tennant; etc.). 6 8 12 16 17 18 23 20 1st Choice CE DT DT DT MS MS PC JW 2nd Choice MS CE PC PC JW CE JW CE 3rd Choice DT JW CE JW CE DT DT PC 4th Choice PC MS JW MS PC PC CE DT 5th Choice JW PC MS CE DT JW MS MS Is there a Condorcet winner?Answer: Explain: Do any of the voting methodsPlurality Method, Instant…
Consider the following three simple rules to represent fuzzy relationship between food quality and service in a restaurant as input variables and tip amount as output variables. 1) If the food is bad OR the service is poor, then the tip will be low 2) If the service is acceptable, then the tip will be medium 3) If the food is great OR the service is amazing, then the tip will be high. Given the membership functions illustrated in Figure 1 and 2 as follows. Using the clipped center of gravity method, compute the tip amount based on the following circumstances: 1) Food quality was 6.0, and 2) Service was 8.0
Create an ER Diagram for the following scenario. Please state any assumptions you have madein your answer.A university offers a Mathematics program. This program can offer any amount ofcourses in a semester. Each course has a roster limit, location and time slot. A studentcan be registered for any number of courses in a semester but to register for a coursethey must have a valid student ID and address. Each course is assigned a singleprofessor. Only on completion of a course, a student receives a final grade for thatcourse.