Query 1 (9 pts)
For a library, the entity kind HOLDING has three subtypes: BOOK, AUDIO BOOK and DVD. Draw a separate EER diagram section for every of the next conditions:
a. At a given time, a holding have to be not less than one in all these subtypes.
b. At a given time, a holding have to be precisely one in all these subtypes.
c. A holding might or is probably not one in all these subtypes. Additionally, a holding could also be any two or three of those subtypes on the similar time.
Query 2 (11 pts)
Draw an EER diagram for the next downside. Ensure all cardinalities are represented. If the knowledge offered aren’t sufficient, state any assumptions that you’ve got made whereas drawing your diagram. An organization posts job opening on-line. Job seekers should apply for these jobs on-line as nicely. The corporate has a strict coverage that just one job utility is allowed for every job seeker. Job openings normally have a number of candidates, however it’s attainable for some opening to don’t have any applicant. Solely job seekers who utilized for a job opening are saved within the database. Job seekers have a singular ID quantity, a reputation, an deal with, a piece historical past and . A job posting have to be both for a part-time or full-time place and people two place varieties are distinct from one another. Half-time positions have a complete variety of weekly hours and an hourly price. Full-time positions have a month-to-month wage. Each sorts of job listings have particulars in regards to the place title, and expertise required in addition to a singular job opening ID. For some, however not all, of the full-time job openings, the corporate ask recruiting companies to deal with the hiring and interview course of. The corporate works with a number of recruiting companies, and preserve details about the company title, contact particular person title and cellphone quantity, along with an assigned company identification quantity. Whereas a recruiting company have to be accountable for a number of full-time job openings, every full-time job opening will be assigned to just one company till the place is crammed.
-research paper writing service