My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
|
Resources » Articles/Knowledge Sharing » Education »
Dbms question
|
Instructions
• Questions will be asked from both the parts (A and B)
• You have to write only Part B questions.
• Leave the italics questions in part B
------------------------------------------------------------------------------------------------------------
PART A
Draw an E-R diagram showing the cardinality for the following:
A bill is sent to a customer. A customer can receive many bills.
A clerk works in a bank. The bank has many clerks
A part is used in many products and a product uses many parts.
Students apply for seats in colleges. Each student can atmost get one seat. A college has many seats. A student can send many applications.
A car is owned by a person. The person can own many cars.
Develop E-R diagram for the following:
Customer withdraws money from his account
Students write examinations.
Students attend classes
Professors write books
Driver drives a car
Explain the following with example
Domain
Cardinality of a relationship
Degree of a relation
Domain constraints
Conceptual Schema
Data Model
Dbms
Data dictionary
Attributes
Relationship
Entity
Entity set
Relationship set
Integrity constraints
Domain constraints
foreign key
referential integrity
Data
information
Database
Rdbms
Data integrity
Entity integrity
Referential integrity
Tuple
Domain
Data redundancy
Data abstraction
Metadata
Views of data
Explain Difference between the following(give examples wherever necessary)
Physical schema & logical schema
Two tier and three tier client server architecture
Weak and strong entity set
Total participation and partial participation of an entity set
Ddl and dml
Physical and logical data independence
Composite and multivalued attribute
Unique and primary key
Candidate and super key
Procedural and non procedural languages
Generalization and specialization
Selection and projection operation
Instance and schema
Disadvantages of file systems
Truncate and delete command
Primary key and foreign key
Drop and delete
Alter and update
write sql and relational algebra queries for the following relations
Employee (Emp_no, Name, Emp_city)
Company (Emp_no, Company_name, Salary)
(i)display Employee name and company name.
(II)display employee name, employee city ,company name and salary of all the employees whose salary >10000
Student(roll-no, name, date-of-birth, course-id)
Course (Course-id, name, fee, duration)
(I)List all those students who are greater than 18 years of age and have opted for
MCA course.
(II)List all those courses whose fee is greater than that of MCA course.
Student (roll-no, name, subject-name, subject-opted)
Subject(faculty-code, faculty-name, specialization)
(I)Find the number of students who have enrolled for the subject "DBMS".
(II)Find all those faculty members who have not offered any subject.
Branch (branch-id, branch-name, customer-city, branch-id)
Customer (customer-id, customer-name, customer-city, branch-id)
(I)List all those customers who live in the same city as the branch in which they
have account.
(II)List all those customers who have an account in a given branch city.
Book(accession-no, title, publisher, year, date-of-purchase, status)
Member(member-id, name, number-of-books-issued, max-limit)
Book-issue(accession-no, member-id, date-of-issue)
(i) List all those books which are due from the students to be returned. A book is considered to be due if it has been issued 15 days back and yet not returned.
(ii) List all those members who cannot be issued any more books.
Branch (branch-id, branch-name, customer-city)
Customer (customer-id, customer-name, customer-city, branch-id)
(i) List all those branches who have more than 100 customer.
(ii) List all those customers who have an account in more than one branch.
PART B
• List 5 DBMS applications.
• Give the distinction between primary key, candidate key and super key.
• What do you mean by cardinality? What are different kinds of cardinalities?
• What are the Components of storage Manager?
• Steps involved in processing a query.
• Functions of dba.
• Various database users.
• What are weak and strong entities? How are they represented in E-R diagram?
• Types of attributes? How are they represented in an e-r diagram?
• What are various components of Database System ? Explain in detail.
• What do you mean by data models ? Explain network, hierarchical and relational model in detail.
• Explain various levels of Data abstraction in database system ?
• What do you mean by database ? What is the purpose of a database system ? .
• What do you mean by DBMS ? Explain its functioning.
• Explain architecture of DBMS and its advantages ? state two main disadvantages of DBMS ?
• What is DBA ? What are major responsibilities of DBA and database designers ?
• What are problems with traditional file processing system ? How they are removed in database system ? Explain
• What do you mean by Entity-Relationship Diagram ? Explain
• Explain the various terms of an E-R model and how are they represented in an E-R model ?
• What is meant by term relationship between entities ? Explain the different types of relationships that can exist with examples ?
• Explain the concept of weak entitiy set ? give example.
• What do you mean by mapping cardinalities ? Explain various type of cardinalities.
• What is difference between total and partial participation ? Explain.
• What is the difference b/w single and multivalued attributes ? Explain.
• Explain the concept of participation constraints ?
• Discuss the various update operation on relation and types of integrity constraints that must be checked for each update operation ?
• Discuss the various types of join operations ? Why are these join required ?
• What do you mean by normalization ? Explain.
• What do you mean by BCNF ? Why it is used and how it differ from 3 NF ?
• Describe the three-level architecture of DBMS ? Also explain its importance in a database environment.
• Discuss concept of database language and interfaces.
• Give the various advantages and disadvantages of the network model.how it differ from relational model ?
• What is relationship ? What are various types of relationship ? Explain with example.
• Explain the Codd’s Rule in detail.
• What do you mean by RDBMS ? What are its characteristics ?
• Explain Entity integrity and Referential integrity in detail.
• What is the difference between DBMS and RDBMS ? Which of them is more suitable?
• What is relational algebra ? Discuss the various operations of relational algebra.
• What is relational calculus ? Differentiate relational algebra and relational calculus.
• What do you mean by Null values? Explain with suitable examples.
• Why normalization needed ? What are its disadvantages ?
• Discuss the various normal form in normalization with suitable examples.
• Define term anomalies. Explain BCNF in detail.
• Why is concurrency control needed? Explain lost update, Inconsistent retrievals and uncommitted dependency anomalies.
• What is a deadlock ? How can a deadlock occur ? explain.
• Briefly explain one deadlock prevention algorithm.
• What if time stamping is used ? Explain briefly
• What is two-phase locking and how does it guarantee serializability ?
• Discuss the concurrency control mechanism in detail using suitable example.
• Differentiate between Two phase locking and Rigorous two-phase locking.
• How can deadlocks be avoided when using 2PL?
• How Share and exclusive locks differ ?Explain.
• How precedence graph can be used to detect deadlock ?
• What is a system log ? What is the purpose of the system log in system recovery ?
• What do you understand by distributed databases? Give the various advantages and disadvantages of distributed database management system.
• Explain the architecture of Client-Server databases in detail.
• What are the main differences between a parallel and a distributed system ?
• Discuss the concept of Query Processing .What is a parser ? Why it is used ?
• What is Query optimization ? What are different techniques used in it.
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
Advertise Here
|