Consider the following description for a university database system, split into numbered sentences for easy reading:

(i) The university offers several modules, and students can enroll into one or more modules.

(ii) Each module, identified using a unique ID, will involve multiple assignments.

(iii) Each assignment will be allocated a number that is unique within that module (but not necessarily across modules).

Which entity among those in the description is suitable to be modeled as a WEAK ENTITY SET?

A. Assignment

B. Module

C. Students

D. University

Solutions

Expert Solution

The weak entity here will be Assignment and the reason behind that will be that according to the defination of weak entity , it is that entity which cannot be uniquely identified by its attributes alone it needs a foreign key as well in conjunction with its attributes to create a primary key which in our example is clearly visible that assignment cannot be uniquely identified by its allocated number alone it would require its module ID as well because the assignment number is unique in that model only.

venereology answered 1 year ago

Next > < Previous

Related Solutions

Consider a university database for the scheduling of classrooms for final exams. This database could be...

Consider a university database for the scheduling of classrooms for final exams. This database could be modeled as the single entity set exam, with attributes course-name, section-number, room-number, and time. Alternatively, one or more additional entity sets could be defined, along with relationship sets to replace some of the attributes of the entity set, as • course with attributes name, department, and c-number • section with attributes s-number and enrollment, and dependent as a weak entity set on course •...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track...

Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address, and to...

Q1.Consider an inventory system in discrete time with the following description. At the beginning of the...

Q1.Consider an inventory system in discrete time with the following description. At the beginning of the period the inventory decreases by one unit if the inventory level at the beginning is positive other the level remains zero till the end of the period. At the end of the period nth period, the inventory is increased by an amount Vn, where {Vn|n ≥ 1} is i.i.d. with P{V1 = i} = pi , i ≥ 0. Let Xn denote the level...

Q1.Consider an inventory system in discrete time with the following description. At the beginning of the...

Consider the University Database with the following relations: Professors (pid, pname, dept, ext) Students (sid, sname,...

Consider the University Database with the following relations: Professors (pid, pname, dept, ext) Students (sid, sname, major-dept, year) Courses (cid, cname, dept, credithours) Enrollment (sem-year, sid, cid, grade) Teaches (pid, cid, sem-year, class-size) where, Professors: All professors have professor id (pid), name (pname), department that they work (dept), and a phone number extension for their office (ext). Students: All students have id (sid), name (sname), department for their major (major-dept), and a year (year i.e, freshman, sophomore, junior, etc). Courses:...

Consider the University Database with the following relations: Professors (pid, pname, dept, ext) Students (sid, sname,...

Consider the University Database with the following relations: Professors (pid, pname, dept, ext) Students (sid, sname, major-dept, year) Courses (cid, cname, dept, credithours)Enrollment (sem-year, sid, cid, grade) Teaches (pid, cid, sem-year, class-size), Professors: All professors have professor id (pid), name (pname), department that they work (dept), and a phone number extension for their office (ext). Students: All students have id (sid), name (sname), department for their major (major-dept), and a year (yeari.e, freshman, sophomore, junior, etc). Courses: All courses have...

Consider the following set of requirements for a university information system that is used to keep...

Consider the following set of requirements for a university information system that is used to keep track of students’ transcripts. R1: The university keeps track of each student's name, student number, class, and degree program. R2. The university consists of various departments. Each department is described by a name, department code and phone. R3. Each course has a course number, course name, and credits. R4. Each section has an instructor, course number, and section number. There might be multiple sections...

Pls do not handwritten for easy reading === === Question:- The following are mutually exclusive scenarios....

Pls do not handwritten for easy reading === === Question:- The following are mutually exclusive scenarios. a) During 20X2 , a Singapore-incorporated company, JK Pte Ltd, discovered that the inventory as stated in the published 20X1 statement of Financial Position was overstated by $150,000. JK Pte Ltd uses a periodic system and the First-In-First-Out cost method. Discuss and determine the accounting treatment of this overstatement in JK Pte Ltd's book based on FRS 8 Accounting Policies, Changes in Accounting Estimates...

14.19. Suppose that we have the following requirements for a university database that is used to...

14.19. Suppose that we have the following requirements for a university database that is used to keep track of students’ transcripts: a. The university keeps track of each student’s name (Sname), student number (Snum), Social Security number (Ssn), current address (Sc_addr) and phone (Sc_phone), permanent address (Sp_addr) and phone (Sp_phone), birth date (Bdate), sex (Sex), class (Class) (‘freshman’, ‘sophomore’, … , ‘graduate’), major department (Major_code), minor department (Minor_code) (if any), and degree program (Prog) (‘b.a.’, ‘b.s.’, … , ‘ph.d.’). Both...

Consider for the following subquestions a university medical services department. - Consider a university medical services...

Consider for the following subquestions a university medical services department. - Consider a university medical services department. Describe what could be the typical information items that are kept within the information system of such a department. -What details should be included in a typical physical vital records inventory specifically for at least one type of data records at such a medical services department which is needed for business recovery planning. -Describe the typical functions of a university medical services department...

Subjects