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

Sub Class and Super Class belongs to model. a. ER b. Dimensional C. EER d. Relational Which of the following is true about Information? a. It is always useful without processing b. It is generally collection of unorganised facts c. It needs to be processed to provide answer to user queries d. It is raw Which of the following statements is true about the Composite Primary key? O a. It is composed of two or more attributes, but it must be minimal. b. It is composed of two or more relations, but it must be minimal. O c. It is composed of two or more attributes, but it must be maximal. d. It is composed of two or more entities, but it must be minimal. contains only columns that are non-transitively dependent on the primary key. a. INF b. 2NF c. 3NF d. UNF
Consider the following class diagram that models a company activities. A company is composed of many branches and each branch is located in a different city. Company's customers are subdivided into two categories: Regular and Privileged. Privileged customers are those that made at least 10 orders to the company. A customer can order items to the branch in his city, if any. The order will than be recorded by this branch. An order consists of a list of items. A discount of 5% will be applied for privileged customers. A discount of 10% will be applied if the order contains more than 8 items or if the total price of the order exceeds 100. Customer Order Item name: String name: String 0. date:Date /discount int name: String priceint 0. 0. canMakeOrder():Boolean isPrivileged() Boolean 0. 0. City Branch 0..1 name: String naner String Express the following constraints in OCL. 1. The number of items in an order does not exceed 15. 2. The number of items in an order does not exceed 10 for…
Question 3 With reference to the UML class diagram, write the Java code for the IPad and ApplelD classes as described in the UML diagram. You need to identify the missing attribute and the parameters of the constructor. IPad ApplelD -model: String -year: String -email: String -? -username: String 1 +IPad(????????) +ApplelD(email: String, userName: String)
How do you model the following situation with a uml2 class diagram There are exactly two kinds of participants, namely members and guests. Guests are invited by members
Class Employee Employee -Name (string) -ID(integer) -Address(string) -Salary(double) -Nationality(string) -ExtraWHours(int) +>( Name,ID) +void setdata( Address,Salary, ExtraWHours) 1. Regarding to the UML diagram create class Customer 2. Create the constructer Employee that read the Employee Name and ID and set the Nationality to Kuwaiti 3. Use the method setdata that set the remaining class data , this method verify that the number of extra working hours is greater than 5 to set the number to ExtraWHour otherwise set the number 1 + Overtime() to this data member + . get methods 4. create gets methods for all data member 5. calculate Employee overtime in Overtime method this method return double value after calculating the overtime by using the following formula Overtime = (Salary * 0.25)* ExtraWHours Test File 1. declare the object Employee1 with Name Fahad and id 7788 2. Ask the user to enter object data (Address, Salary, ExtraWHours) for the Employee1l objects 3. Set the data for…
Question 02: Write five examples of each of the following from real life also draw UML of each example.1. Association2. Aggregation3. Composition
Based on the provided information below, what would be the entities and the relationship between each one? Thank you!
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 _______?
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME EMPLOYEE P_ID EMP_HIRE_DATE STUDENT P ID STUDY_MAJOR PK, FK1 PK, FK1
Imagine that the final exams for five courses need to be sched- uled, and only two time slots are available. There are plenty of classrooms, but no student can take two exams simultaneously. The classlists for the five course are • Classlist for course 1: ci {Akiko,Erin,Sandy} • Classlist for course 2: c2 {Carl, Dan, Wilma} • Classlist for course 3: c3 {Akiko,Bart,Terry} • Classlist for course 4: C4 {Erin, Dan, Val} • Classlist for course 5: c5 {Carl, Bart,José}
Create a UML Class Model based on the requirements . Your Class Model is to include: All classes Attributes and Attribute Types Associations Multiplicity Primary and Foreign keys Any Inheritance, Composition or Aggregation. Building Maintenance system. A rental property management company wants to develop a ‘Building Maintenance System.’ This system will be used by the company to manage maintenance requests from tenants in the several rental buildings that it manages in the city. Each building has a maintenance manager. The maintenance manager is responsible for creating accounts in the system for each tenant in their building. A tenant can rent multiple apartments within the same building. Tenants can submit maintenance requests using this system. Each maintenance request will have a request ID, category, and description. The maintenance manager manages a maintenance crew in their building. Maintenance crew members can be members of more than one maintenance team. Maintenance crew…
I hope you are well, I drew this uml (class diagram) I want to ask if it is correct and the relationships are correct or add any modifications from you ... Thank you I want it necessary