please Answer the 4 quastion beloe correctly without pilgrism

in /by

please Answer the 4 quastion beloe correctly without pilgrism

Q1

Does the relational model, as seen by an SQL query writer, provide physical and logical data independence? Explain using an example.

————————-

Q2

Consider the following relations:

Student(ssn, name, address, major)

Course(code, title)

Registered(ssn,code)

Answer any FIVE. Each question

1. List the codes of courses in which at least one student is registered (registered courses)

2. List the titles of registered courses (of those in 1.)

3. List the codes of courses for which no student is registered

4. The titles of courses for which no student is registered.

5. Names of students and the titles of courses they registered to.

6.SSNs of students who are registered for

‘Database Systems’ or ‘Analysis of Algorithms’.

—————————————————-

Q3

Explain the distinctions among the terms primary key, candidate key, and super key with appropriate examples.

—————————————————

Q4

Consider that you are asked to design an entity relationship diagram based on the below scenarios:

A hospital with a set of patients and a set of medical doctors. Each patient associate with a log of number of tests and examination conducted. Each test is performed by a doctor. This database can be modelled as three entity sets Test(test_ID, test_name, date, time, result), Patient(ID, name, DB, registration_date) and Doctor(ID, name, specialisation)

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper