Course Name: Database Management Systems
Course Code: UE19CS301
Unit : 1
1. Discuss the main characteristics of the database approach and how it
differs from traditional file systems?
2. What are the different types of database end users? Discuss the main
activities of each?
3. Give examples of systems in which it may make sense to use traditional
file processing instead of a database approach?
4. Explain when not to use DBMS?
5. Define the following terms: data, database, DBMS, database system,
program-data independence, user view, DBA, end user, persistent object,
meta-data.
6. Explain with a example what is scheme, instance and database state?
7. Describe the three-schema architecture. Why do we need mappings
among schema levels? How do different schema definition languages
support this architecture?
8. What is the difference between logical data independence and physical
data independence? Which one is harder to achieve? Why?
9. Define the following terms: relation schema, relational database schema,
domain, relation instance, relation cardinality, and relation degree.
10.What is the difference between a database schema and a database state?
11.List the various cases where use of a NULL value would be appropriate
12.Define the following terms: entity, attribute, attribute value, relationship
instance, composite attribute, multivalued attribute, derived attribute,
complex attribute, key attribute, and value set (domain).
13.What is a relationship type? Explain the differences among a relationship
instance, a relationship type, and a relationship set.
14.Describe the two alternatives for specifying structural constraints on
relationship types. What are the advantages and disadvantages of each?
15.What is meant by a recursive relationship type? Give some examples of
recursive relationship types.
16.Discuss the conventions for displaying an ER schema as an ER diagram.
17.A database is being constructed to keep track of the teams and games of
a sports league. A team has a number of players, not all of whom
participate in each game. It is desired to keep track of the players
participating in each game for each team, the positions they played in that
game, and the result of the game. Design an ER schema diagram for this
application, stating any assumptions you make. Choose your favourite
sport (e.g., soccer, baseball, football).
18.Given the ER schema for the MOVIES database in Figure, draw an instance
diagram using three movies that have been released recently. Draw
instances of each entity type: MOVIES, ACTORS, PRODUCERS, DIRECTORS
involved; make up instances of the relationships as they exist in reality for
those movies.
19.Consider the ER diagram of company database from textbook and
Assume that an employee may work in up to two departments or may not
be assigned to any department. Assume that each department must have
one and may have up to three phone numbers. Supply (min, max)
constraints on this diagram. State clearly any additional assumptions you
make. Under what conditions would the relationship HAS_PHONE be
redundant in this example?
20.Discuss the role of a high-level data model in the database design process.
21. Difference between a Database schema and Database Instance/
Database State.
22.Mention the different Database states.
23. What are the advantages of 3-schema architecture?
24. Explain 3-schema architecture
25.What is data independence and mention its different types.
26. What are the different types of DBMS languages.
27.What are the different types of Data Manipulation Languages.
28.Explain the different types of interfaces available for DBMS.
29. What are the different types of Programmer interfaces for embedding
DML in a programming languages
30. What are the different types of User-Friendly DBMS Interfaces
31. What is the difference between Centralized and Client-Server DBMS
Architectures .
32. Explain Three-tier client-server architecture
33. What are the data models that exists in DBMS.
34.Discuss relational Model.
35.Explain in detail the Database design process and what is its importance
on the database design.
36. What are Entities and Entity Sets?
37. Discuss different types of attributes that describe the Entity set.
38.With a suitable example explain how Recursive Relationship is
represented in ER diagram.
