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

Alex and Josh opened Stories on CD Company, Inc., a family-owned business that sells audio CDs of classic and best-selling children's stories. The Company has a number of distributors from whom they purchase the CDs for resale. For selling purposes, the CDs are classified by appropriate age groups: 4–6; 7–10; and 11–14. Roughly 30% of total sales occur within their single retail store; the remaining 70% are through mail order. Sales are particularly strong during the summer vacation months and Christmas shopping season. When the business opened, Ted created a simple computerized database to handle customer orders and sales. A data form is filled out every time a customer places an order, and includes the following:
Nomenclature is a system for giving names to things within a particular profession or field. The XYZ Exporters and Co. is a new firm in Pakistan having two units in Karachi & Lahore. They decided to generate employee numbers using a specific pattern by applying nomenclature. This pattern consists of unit identification, department identification, employee appointment month, year and he/she will be having a unique registration number. The top management of XYZ Exporters and Co. has approved the following pattern for the employee numbers. Unit Code - Department Code / Joining Month Code - Joining Year - Employee Unique Number This Firm currently has five departments, HR, IT, Exports, Accounts & Finance, & Production, and two units Karachi & Lahore and their codes are as under: Department Name Department CodeHuman Resource 01Information Technology 02Export 03Accounts & Finance 04Production 05 Unit Name Unit CodeKarachi 1Lahore 2 Month Month CodeJanuary M01February…
Sur University Registration - System Scenario: Sur university Registration department (SRD) wants to develop Sur University Registration System (SUReg S), in order to automate the registrations processes, The (SUReg_ S) existing system can be described as follows, the systems stores the following data for faculty_Members ( staff_No, staff_name, dep), for students store the following data (stu_ID, Stu_Name, Stu Address), for (SRD)'s employee saving the following data: (emp_No, job). The (SRD) focusing on the following activities, register courses for students, Entering students marks, calculate total marks, process the result. Calculating the student's total marks, requires checking two important issues firstly check that the student has registered in the required semester, as well as student's absent ratio is less than 20% in all courses. Finally (RAD) announced the students result for a semester or two semesters. Answer the following questions: [Based on the above scenario] A- Create…
A Company operates many factories. Each factory is located in a region. Each region can be “home” to many of the factories. Each factory employs many employees, but each of those employees is employed by only one factory.”
A university offers a number of courses and each semester, it offers zero or more sections of every course. The relationship between entity sets course and the sections offered by the course in a given semester is Question 3 options: a) One-to-many from course to section b) Many-to-one from course to section c) One-to-one from course to section d) Many-to-many from course to section
Question#05 b part Please provide detailed solution with explanation and justification asap to get a upvote for B part
BU School of Witchcraft and Wizardry is a school of magic that sends admission letters only to children with magical abilities. The admissions process for BU School of Witchcraft and Wizardry is as follows:- If both parents of the child have previously studied at BU, they do not need to reply to the admission letter. Otherwise they need to reply to the admissions letter by July 31. If they do not reply by the specified date, they are not accepted to the school. BU has 4 houses that students are sorted into by the sorting hat “Hayri”. These houses are; Gryffindor, Hufflepuff, Ravenclaw and Slytherin. Hayri sorts the students into houses according to 2 characteristics; braveness and intelligence.- If Hayri finds the student to be brave and intelligent, they are sorted into Gryffindor.- If the student is found to only be brave, they are sorted into Slytherin.- If the student is found to only be intelligent, they are sorted into Ravenclaw.- Finally, if they are neither brave nor…
Muscat Auto Workshop is a vehicle service centre located in the city ofMuscat, which provides vehicle maintenance/repair services.The charges of vehicle maintenance/repair are based on the type of the service. Details of charges are as follow: Basic Tuning: 50 OMRSoftware Re-installation: 60 OMRParts Replacement: 100 OMRBody Paint: 120 OMR The workshop offers 10% discounts to the customers who have membership of the service centre. Draw a flow chart diagram that takes customer’s name, car plate number, membership status(Y/N) and the required service (mentioned above). The program outputs the input data and maintenance charges based on the service provided by the service centre with discount, if applies.
EXERCISE 4 For the following NFA, construct an equivalent DFA. 1 90 1 93 € 91 1 94 0 € 0 92 1 95
Duyong Beach Resort is a contemporary hotel that offers rooms with private balconies that face the sea. Your company has obtained a contract from Duyong Beach Resort to design, maintain and update their online reservation system. All room's prices are subjected to tax and service charge. Therefore, total room price must include 6% of tax and 10% of service charge. Table 1 lists price per night, tax, and service charge for all type of rooms. (b) Room Type Standard (S) Deluxe (D) Family (F) (c) (a) float calculate_basicPrice (char roomType, int night) ● You have been assigned to create and implement this task using C program. You have been instructed to include the following functions: Table 1: List of Price for All Rooms Price per Night Tax Charge RM 230.00 RM 300.00 RM 420.00 accept roomType and reservation duration (night) from main function calculates basic room price for number of night(s) entered according to Table 1 return basic room price to main function void calculate_charges…