Why do you need to study Database Management Systems? (Write in your own language and point wise)

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1. Why do you need to study Database Management Systems? (Write in your own language and point wise)

2. Why is the role of the database Administrator (DBA) most important?

3. Consider a two dimensional integer array of size n x m that is to be used in your favourite programming language. Using the array as an example, illustrate the difference between (a) three levels of data abstraction, and (b) between a schema and instances. When you fill the values in the array, the first 9 digits of the first row must be your registration number and first 10 digits of the last row must be your mobile no.

For example, if your Registration no is D202119178 and mob no is 9153159313 then your array will be filled up as

4. Draw the structure of a complete database system to depict the responsibilities of each module (Storage manager and Query Processor )in the overall system.

5. Suppose you have been assigned a project "College Management System" for your own Institute. Your role in this project is to design the database for it. So you draw the required E-R diagram for it using proper symbols.

NOTE: You must include these five entity sets: Student, Teacher, department, Subject, Classroom with minimum five attributes of each. If you wish you may include a maximum of ten entity sets in this diagram.

You must show the primary key foreign key relationship, and all possible types of attributes using their proper symbols.

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of