Q1. Suppose we have a University System. The university has three departments CS, IT and CNET. Each department has students, the students can be regular students or irregular students.Following are the classs and attributes in the university system: Class University, Fields : University_Name, University_Type, Location. class IT Dept, Fields: Dept code. class CS Dept, Fields: any 2 fields class CNET Dept, Fields : any 2 fields class Student, Fields : studentName, studentID. Class ReglarStudent, Fields: any fields of your choice Class IrregularStudent, Fields: any fields of your choice class StaffMembers, Fields: stafflID.

Q1. Suppose we have a University System. The university has three departments CS, IT and CNET. Each department has students, the students can be regular students or irregular students.Following are the classs and attributes in the university system: Class University, Fields : University_Name, University_Type, Location. class IT Dept, Fields: Dept code. class CS Dept, Fields: any 2 fields class CNET Dept, Fields : any 2 fields class Student, Fields : studentName, studentID. Class ReglarStudent, Fields: any fields of your choice Class IrregularStudent, Fields: any fields of your choice class StaffMembers, Fields: stafflID.

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

While mapping an object model to a relational database, we have two options for realizing inheritance: vertical mapping (using a separate table for the parent class) and horizontal mapping (duplicating columns). In which of the following cases you prefer vertical mapping? I. You anticipate that the parent class will change often in the future. II. Query response time is not a major concern. III. Run-time efficiency is the main design goal. IV. Modifiability is the main design goal. A Only III B II and IV C I, II, and IV D I and III E All of them
A hotel reservation system supports the following functionality: (a) Room reservation (b) Changing the properties of a room (for example, from non-smoking to smoking) (c) Customer check-in (d) Customer check-out Come up with system use cases for the above functionality and draw the domain model (please explain how you found the classes,attributes and associations in your model considering the analyses you have made).
In the below sequence diagram which represents a use case for Search book, there are 5 objects from the five classes. Which classes are not entity classes and why?✓ Sadit Khan posted Mar 17, 2023 3:35 PM Subscribe Search Book: Use Case Search Page Search Results Page Catalog Search Results Customer -Main scenario- The Customer specifies an author on the Search Page and then presses the Search button. 1: on Search(author) The system validates the Customer's search criteria 1.1: validateSearchCriteria() alt, If author is entered, the System searches the Catalog for books associated with the specified author. author entered] 1.2 searchByAuthor(author) 1.2.1:create() When the search is complete, the system displays the search results on the Search Results page. -Alternate path- If the Customer did not enter the name of an author before pressing the Search button, the System displays an error message author not entered] 1.2.1.1: display() 1.3: display ErrorMessage()
From the below Class Diagram it looks that the number of registrations are unlimited as the number of attendants are specified from 0 to *. However, this is actually a flaw in the UML that we cannot put constraint on objects or on the instances. Suppose that the No of Registrations is restricted to 50 or 300 depending on the type of Webinar. Draw an OCL model for the supposition we made i.e. put a constraint on the number of registrations in the webinar.
Create a knowledge base using frames for the description of the domain given below. Arepresentation must contain at least one class frame and all types of relations available inframes. Roland Greenberg was born in Germany in 1973. He is a sociologist by his education and has 15scientific publications. Roland collects stamps. His collection consists of 36,000 stamps from 1910to 1960. The follwoing information is known about each stamp: year of issue, title, country,monetary value and special marks (if any). One of the stamps is a stamp issued in Germany in1942 "Make the planet free!". It costs 50,000 EUR, because the stamp of the German post is seton it. Another stamp is the "Classic Fashion" released in France in 1956. It costs 3000 EUR. Could you please solve problem given above? Thanks
Think of a classification problem from your own experience and interest (e.g., distinguishingbetween two types of things/living beings/weather/personality/vehicle/industry/sports/houses/professionals etc.) Collect some real-world data to solve that classification problem. Have at least two classes, two attributes and atleast 5 instances per class. Create a dataframe with this data and paste a screenshot of it. Also give a short description of the data (number of instances, number of attributes and the list of attributes and list of classes). The attributes should be numerical. The classification problem should be a new one, but the dataset may contain data that are new (generated by you by any rough measurements) or collected from public domain. Please cite the references/sources from which you collect the data.
VirtualClass: A Learning Management System for Online Education" system:A Brainstorm with your team to develop a set of Class responsibilities and collaboration “CRC cards” for all entity type classes. Add the CRC index cards to Appendix E of your SRS document under class diagrams. B Based on the responsibilities and collaborations identified in your CRC index cards update your first cut domain class diagram with the following: a. Class attribute descriptions and visibilities b. Signature methods with the respective parameters and visibilities Add the class diagram to Appendix E of your SRS document under class diagrams.
Registered user can book online for movie ticket. They can search for movies, select the appropriate time and data, and make payment. Admin is going to add new movies into database. Draw a class diagram for the scenario given by adding appropriate attributes and functions for each class. Show the relationship among classes with correct cardinality.
draw the Class Diagram to have nessasary these (Generalization, Aggregation, Composition, Association and multiplicity) relations. to Android Application for Healthcare Management System (HMS) where these system are from classes as follow: 1-class doctor 2-class patient 3-class pharmacist 4-class doctorAppointment 5-class doctorCategory 6-class patientAppointments 7-class patientReports 8-class pharmacyOrder 9-class orderHistory
In Chapter 3, you identified use cases and considered the domain classes for the State Patrol ticket-processing system. Review the descriptions in that chapter for the use case Record a traffic ticket. Recall that the domain classes included Driver, Officer, Ticket, and Court. Draw a DCD for the ticket-processing system based on the four classes just listed and include attributes, association, and multiplicity.
Make class diagrams in star uml, locating the respective relationships and methods: 1. Each client has a single discount and a single credit limit. 2. A customer can have more than one delivery address. 3. Each provider has a unique address and a unique credit limit. 4. Each supplier can have several payment terms. 5. Items, like deposits, are coded. 6. An item may be stored in more than one warehouse. 7. An item will have a unique location and quantity in each warehouse where it is is stored. 8. An item may be supplied by several suppliers, but the unit price of each provider may be different. 9. Purchase order numbers can be repeated for different customers, but not for the same client. 10. Each purchase order has a unique dispatch address and a unique date. 11. A purchase order can contain one or more items, but can only do a single order for each item. 12. Purchase orders are numbered. 13. A supplier purchase order can include several items, but one item does not It can appear more…
Read the following description carefully: In a Course Management System, the class Course has the following attributes: courseCode, courseName, credit and courseType. Both the courseCode and courseName are String and their length can be of maximum 6 and 30 respectively. Courses can be of either Theory or Lab in type. What should be the data type of credit and course Type, so that an object of Course does not occupy more than 75 Bytes? Q. Data Type for credit and courseType should be______ and _______?