3rd SEM : Model Question Paper- Programming in C
| Test/Date and Time | Semester/year | Course/Course Code | Max Marks | ||||
| Ex: I test/6 thweek | III SEM | Data Base Management Systems | 20 | ||||
| of sem 10-11 AM | Year: 2015-16 | Course code:15CS33T |
| ||||
| Name of Course coordinator: Units:1,2 Co: 1,2 Note: Answer all questions | |||||||
| Questio n no | Question | CL | C O | PO | |||
| 1 | Definethefollowing. (5) 1. Data Model 2. Database Schema/Intension 3. Database State/Extension 4. Data Sublanguage 5.DML. | R | 1 | 1,2 | |||
| 2 | Define data independence and explain different typesof it. (5) | R | 1 | 1,2 | |||
| 3 | Explain the different cardinality ratios for binary relationship types. (5) | U | 2 | 1,2 | |||
| 4 | Explain with suitable examples 1:1 and M:Nrelationshiptypes. (5) OR Develop an E-R diagram for a company database. | A | 2 | 1,2 | |||
Format for Student Activity Assessment
| Collection of data | Does not collect any information relating to the topic | Collects Collects very limited some basic information; information; somerelate refer to the to the topic topic | Collects Collects a relevant great deal of information; information; concerned all refer to to the topic the topic | 3 |
| Fulfill team's roles & duties | Does not perform any duties assigned to the team role | Performs Performs very little nearly all duties duties | Performs all Performs all duties duties of assigned team roles with presentation | 4 |
| Shares work equally | Always relies on others to do the work | Rarely does Usually the assigned does the work; often assigned needs work; rarely remindingneeds reminding | Doesthe Always assigned job does the without assigned having to be work reminded. without having to be reminded and on given time frame | 3 |
| Listen to other Team mates | Is always talking; never allows anyone else to speak | Usually Listens, but does most sometimes of the talk too talking; much rarely allows others to speak | Listens and Listens and contributes contributes to the preciselyto relevant therelevant topic topic and exhibit leadership qualities | 3 |
|
|
|
| TOTAL | 13/4=3.25=4 |
*All student activities should be done in a group of 4-5 students with a team leader.
Diploma in Computer science & Engineering
III- Semester
Course Title: Data Base Management Systems
Time: 3 Hours Max Marks:100
Answer any SIX questions. Each carries5marks. 5X6=30 Marks
1. What is database? List the important characteristics of databaseapproach.
2. Explain with examples Entity Integrity Constraints and referential Integrity Constraint.
3. Explain the characteristics of Relations.
4. With examples write a note on CREATE and DROPcommand.
5. Differentiate Having and Where clause withexample.
6. Explain the Boyce-Codd normal form withexample.
7. Explain the generation of spurious tuples and how to overcome thesame.
8. Discuss the advantages of NoSql versusRDBMS.
9. What is scaling. Explain the types ofscaling.
PART-B
Answer any SEVEN full questions each carries10marks. 10X7=70 Marks
1. Discuss the advantages of DBMSApproach.
2. Define thefollowing.
3. Data Model b) Database Schema/Intension c) DatabaseState/Extension
4. d) Data Sublanguage. e) DML.
5. With a neat diagram explain the different phases of database design.
6. Identify the entities, relationships and develop an E-R diagram for a company database.
7. Explain with example the different Constraints that are violated during UPDATE and DELETEoperations
1. Consider the following schema & write the SQLqueries. SAILORS (sid, sname, rating,age)
BOATS (bid, bname, color) RESERVES (sid, bid, day)
a. Retrieve names of sailors who reserved greenboat.
b. Retrieve the colors of boats reserved by'ramesh'.
c. Retrieve the names of sailors who have reserved a red or a greenboat.
d. Retrieve the sid of sailors with age over 20 who have not reserved a redboat.
e. Retrieve the names of sailors who have reserved all boats called'Interlake'.
2. List and explain the different data types used inSQL.
3. Discuss the informal design guidelines for relationalschema.
4. Draw a state diagram and discuss the typical states during transactionexecution.
5. Explain the need for concurrencycontrol.
MODEL QUESTION BANK
Diploma in Computer Science & Engineering III Semester
Course Title: Data Base Management Systems
| CO | Question | CL | Marks |
|
I | What is database? List the important characteristics of database approach. | R |
05 |
| What do you mean by data model? List and explain the different types of data model. | R | ||
| What is Data Independence? Differentiate between logical & physical Data Independence. | U | ||
| Define the following. 1. Data Model 2. Database Schema/Intension 3. Database State/Extension 4. Data Sublanguage 5.DML. | R | ||
| Explain the functions of database administrators anddatabase designers. | U | ||
| Briefly explain the different types of End Users. | U | ||
| Define data independence and explain different types of it. | U | ||
| List the various DBMS languages and explain each. | R | ||
| List the various DBMS interfaces and explain each. | R | ||
| Explain the functions of different Database utilities. | U | ||
| Explain the important characteristics of database approach. | U |
10 | |
| Explain the actors on the scene and workers behind the scene. | U | ||
| Discuss the advantages of DBMS Approach. | U | ||
| Explain the two-tier client/server architecture for DBMS with neat diagram. | U | ||
| Explain the DBMS components modules with neat diagram. | U | ||
| Write a note on classification of DBMS. | U | ||
|
II | What is E-R diagram? List out the notations used for E-R diagram. | R |
5 |
| Explain the different cardinality ratios for binary relationship types. | U | ||
| Differentiate between a) an attribute and value set b) stored and derived attributes. | U | ||
| Explain the structural constraints of relationship type. | U | ||
| Explain with suitable examples 1:1 and M:N relationship types. | A | ||
| With a neat diagram explain the different phases of database design. | U |
10 | |
| What is a Weak entity type, explain with an example how the entities are identified in a Weak entity. | U | ||
| Define the following term with examples:- a) Entity b) Entity set c) Multi-valued attribute d) Composite attribute e)Derived attribute | R | ||
| Identify the entities, relationships and develop an E-R diagram for a company database. | A | ||
| Identify the entities, relationships and develop an E-R diagram for a Hospital database. | A | ||
|
III | Compare entity integrity and referential integrity constraints. | U |
5 |
| Classify the constraints on databases and give examples for each of them. | U | ||
| Explain the characteristics of Relations. | U | ||
| Explain with examples Entity Integrity Constraints and referential Integrity Constraint | A | ||
| Differentiate i) Key andsuperKey ii) degree and cardinality | U | ||
| Define the following term with examples:- | R |
| |
|
| a) Domain b) Attribute c) Tuple d) Relation schema(R) e) Relation (r) |
|
10 |
| Explain the insert, delete and update operation with examples. | A | ||
| Explain with example the different constraints that are violated duringUPDATEand DELETEoperations | U | ||
|
IV | Write a note on different data types supported by SQL. | R |
5 |
| Write the general syntax of specifying Check constraint and default constraint while creating a table. | R | ||
| Differentiate Having and Where clause with example. | A | ||
| Write a note on aggregate functions in SQL. | U | ||
| Discuss the strategies for View Implementation. | U | ||
| With examples write a note on CREATE and DROP command. | A | ||
| Define view. How to create it? Give example. | U,A | ||
| Explain UPDATE and ALTER command with example. | U,A | ||
| Write a note on basic queries in SQL. | U | ||
| Explain the different schema change statements in SQL with example. | A | ||
| List and explain the different data types used in SQL. | U |
10 | |
| Explain different constraints available in SQL with example. | U | ||
| List and explain the different aggregate functions available in SQL with example. | A | ||
| Explain the following with examples: a) Insert b) Delete c) Distinct d) Order by e) Where | A | ||
| Explain the following Operators with examples: a) ANY b) ALL c) IN d) LIKE e) BETWEEN | A | ||
| Consider the following schema & write the SQL queries. SAILORS (sid, sname, rating, age) BOATS (bid, bname, color) RESERVES (sid, bid, day) a) Retrieve names of sailors who reserved greenboat. b) Retrieve the colors of boats reserved by 'ramesh'. c) Retrieve the names of sailors who have reserved a red or a green boat. d) Retrieve the sid of sailors with age over 20 who have not reserved a red boat. e) Retrieve the names of sailors who have reserved all boats called 'Interlake'.
And Similar databases to be considered with different set of queries. | A | ||
|
V | Explain the generation of spurious tuples and how to overcome the same. | U |
5 |
| Differentiate between i) prime attribute and non prime attribute ii) Full functional dependencies and partial dependencies with examples. | U | ||
| Explain the functional dependencies with examples. | U | ||
| Explain second normal form with an example. | U | ||
| Explain third normal form with an example. | U |
|
| Explain the Boyce-Codd normal form with example. | U |
|
| Explain the different UPDATE anomalies of tables. | U |
10 | |
| Discuss the informal design guidelines for relational schema. | U | ||
| What is normalization? Explain the different types of normal forms with examples. | U | ||
|
VI | Explain the following terms: transaction, concurrency control. | U |
5 |
| Explain the desirable properties of a transaction. | U | ||
| Write a note on System Log. | U | ||
| Write a note on commit point of a transaction. | U | ||
| Discuss the advantages of NoSql versus RDBMS. | U | ||
| Explain CAP theorem. | U | ||
| Explain the advantages of distributed computing. | U | ||
| What is scaling. Explain the types of scaling. | U | ||
| Differentiate between ACID and BASE. | U | ||
| Bring out the advantages and disadvantages of Nosql. | U | ||
| Draw a state diagram and discuss the typical states during transaction execution. | A |
10 | |
| Discuss the different types of failures that occur during transaction execution. | A | ||
| Explain the need for concurrency control. | A | ||
| Explain the categories of NoSql. | U | ||
| Explain Column store and Row store with suitable examples. | A |
Comments