One Important Key To Success is Self-Confidence....
An Important Key To Self-Confidence is Preparation.....!!
MGM’s College of
Engineering, Nanded.
Department of IT
Semester I (2018-19)
Class: TE(IT) Subject: DBMS Assignment I
An Important Key To Self-Confidence is Preparation.....!!
MGM’s College of
Engineering, Nanded.Department of IT
Semester I (2018-19)
Class: TE(IT) Subject: DBMS Assignment I
1. Draw and explain
DBMs system structure.
2. Compare DBMS with file-processing system.
3. Explain the difference between physical and logical data
independence.
4. What are
five main functions of a database administrator?
5. Write a
short note on: Database Languages.
6. Define:
i) Schema with example ii) Primary key iii) Candidate key and iv) Superkey.
7. A
university registrar’s office maintains a data about the following entities:
(a) courses, including number, title, credits, syllabus, and prerequisites; (b)
students, including student-id, name, and branch; (c) instructors, including
identification number, name, department, and title. Construct an ER diagram for
the registrar’s office.
8. Enlist,
explain with examples attribute types used in an ER model.
9. What are
the different mapping cardinalities used in ER model? Explain briefly.
10. Design
a database for an airline. The database must keep track of customers and their
reservations, flights and their status, seat assignments on individual flights,
and the schedule and routing of future flights. Your design should include an
E-R diagram, a set of relational schemas, and a list of constraints, including
primary-key and foreign-key constraints.
11. Explain
various operations of relational algebra.
12. What
are the major components used to construct an ER diagram? Enlist and explain.
13. What
are the fundamental relational-algebra operations? Explain with examples.
14. Consider
the following relational database:
employee (person
name, street, city)
works (person
name, company name, salary)
company (company
name, city)
Give an
expression in the relational algebra to express each of the following queries:
a. Find the
names of all employees who live in city “Mumbai”.
b. Find the
names of all employees whose salary is less than Rs.11000.
c. Find the
names of all employees who live in “Mumbai” and whose salary is less than Rs.11000.
15. Consider
the following database:
employee (personname,
street, city )
works (personname,
company name, salary)
company (companyname,
city)
Give an
expression in the relational algebra to express each of the following queries:
a. Find the
names of all employees who work for “First Bank Corporation”.
b. Find the
names, street addresses, and cities of residence of all employees who work for
“First Bank Corporation” and earn more than $10,000.
c. Find the
names of all employees in this database who live in the same city as the
company for which they work.
16. Explain
the difference between weak and strong entity sets.
Faculty
Incharge: Hashmi S A
