Database Management Systems- What do you understand by relational data model? Explain relational constraints and relational database schemas Q2. What are the similarities and

What do you understand by relational

Database Management Systems

 

Multiple choices:

Q1. A collection of related sets of data items along with necessary data/ information associated with it.

a. Data

b. Information

c. Process

d. Database

Q2. ___________connects computers which are very remotely placed.

a. Local Area Network

b. Wide Area Network

c. Both (a) & (b)

d. None

Q3. A column in a table is called__________

a. Field

b. Record

c. Tuple

d. Link

Q4. DDL stands for ___________

a. Data Definition Language

b. Data Decision Language

c. Database Definition Language

d. None

Q5. SQL stands for ___________

a. Structured Query Language

b. Statement Query Language

c. Strict Query language

d. None

Part Two:

Q1. List the different types of DBMS.

Q2. Differentiate between „DBMS‟ and „RDBMS‟.

Q3. What do you mean by „Data Dictionary‟?

Q4. Differentiate between discretionary access control and mandatory access control.

Section B: Caselets (40 marks)

Caselet 1

Q1. What are the roles of a database in present scenario?

Caselet 2

Q1. Discuss various anomalies in databases. How would you improve data management in organizations?

Section C: Applied Theory (30 marks)

Q1. What do you understand by relational data model? Explain relational constraints and relational database schemas

Q2. What are the similarities and dissimilarities in the software development life cycle and database development life cycle?

 

 

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

ARAVIND – 09901366442 – 09902787224

 

We are a team of highly committed professionals, who aim at helping Clients to achieve their Goals. We believe in establishing long-term relationships with our clients by delivering value added services of high quality. We are sensitive to our Clients requirements without compromising on values like Integrity and trust. Understanding the abilities, offering them Quality services and meeting our client’s requirements at the right time are our Forte.

 

We are in to this business since 14 years. And we are providing case study Answers, Assignment solutions, Multiple Question Answers and Project Reports of more than 40 + International B School (Indian and Foreign Universities)

 

Currently we are having more than 2, 00,000 Case study Answers. And 4,000 newly created Project Reports.

 

We are global leader in providing help to students for their assignments, projects, homework, Dissertation etc. Our ultimate aim is students best results and there long term relation with us. Our services are focused on, on time delivery, superior quality, creativity, and originality for every assignment we do.