Judgments
DATABASE-SYSTEMS-1-THEORY (1).pdf
- Course
- Technicalcourses
- Institution
- Technicalcourses
DATABASE-SYSTEMS-1-THEORY (1).pdf
[Show more]
Seller
Follow
Content preview
TERTIARY AND VOCATIONAL EDUCATION COMMISSIONCOMMON WRITTEN EXAMINATION
All rights reserved
NVQ Level 05 - Semester I
Information and Communication Technology
Database Systems - I K72C001M01 Three Hours
* Answer any five (05) questions
Question ( 1 )
a) Briefly explain the following terms
I. Primary Key, Composite Key and Foreign Key (06Marks)
II. File Operations &Ordered File (06Marks)
III. DDL & DML (06Marks)
b) Write two advantages of DBMS (02Marks)
Question ( 2 )
Consider the following information: (20Marks)
In an educational institute, there are several departments and students belong
to one of them.
Each department has a unique department number, a name, a location, phone
number and is headed by a professor.
Professors have a unique employee Id, name, phone number.
We like to keep track of the following details regarding students: name, unique
roll number, sex, date of birth, age and one or more email addresses.
Students have a local address consisting of the hostel name and the room
number. They also have home address consisting of house number, street, city
and PIN. It is assumed that all students reside in the hostels.
Course taught in a semester of the year is called a section. There can be
several sections of the same course in a semester; these are identified by the
section number.
Each section is taught by a different professor and has its own timings and a
room to meet. Students enroll for several sections in a semester. Each course
has a name, number of credits and the department that offers it.
A course may have other courses as pre-requisites i.e, courses to be
completed before it can be enrolled in.
Professors also undertake research projects. These are sponsored by funding
agencies and have a specific start date, end date and amount of money given.
More than one professor can be involved in a project. Also a professor may be
simultaneously working on several projects. A project has a unique projectId
Draw an ER diagram for this system.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Studyabroad. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for CA$11.50. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81298 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now