STUPIDSID
Solve any one question from Q.1(a,b) &Q.2(a,b)
1(a)
Explain the distinctions among the terms primary key, candidate and super key with example.
4 M
1(b)
Lis different components used in E-R diagram with their meaning and construct an E-R diagram for car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars, and has one or more premium payements associated with it. Each payement is for a particular period of time, and has an associated due date, and the date when the payement was received.
6 M
2(a)
What is dedlock? List the different dealock prevention schemes. Is starvation still possible? Explain your answer.
4 M
2(b)
State a need of nomalization? Explain 1 NF, 2NF and 3NF with example.
6 M
Solve any one question from Q.3(a,b) &Q.4(a,b)
3(a)
Explain different DDL and DML commands with example.
6 M
3(b)
Explain Transaction Control Commands in SQL with example/
4 M
4(a)
What is serializable schedule? Explain with suitable example the types of serializable. Also explain the significance of precedence graph.
5 M
4(b)
What is Transaction? Explain ACID properties of transaction.
5 M
Solve any one question from Q.5(a,b) &Q.6(a,b)
5(a)
Draw and explain distributed system architecture.
8 M
5(b)
Draw and explain Internet database systems.
8 M
6(a)
Explain two-tier and three-tier architecture.
8 M
6(b)
Explain Data fragmentation and data replication with suitable example with respect to distributed database systems.
8 M
Solve any one question from Q.7(a,b) & Q.8(a,b)
7(a)
What is big data? Explain properties of big data.
8 M
7(b)
What is XML? Explain structure of XML data.
8 M
8(a)
What is significance of Hadoop system? Explain characteristics of hadoop.
8 M
8(b)
Explain Hbase data model with its architecture.
8 M
Solve any one question from Q.9(a,b) & Q.10
9(a)
Define Teradata and explain architecture of Teradata.
9 M
9(b)
Explain:
i) Mobile Database and ii) SQLite
i) Mobile Database and ii) SQLite
9 M
Write short note any three question from Q.10 (a,b,c,d)
10(a)
Datamining.
6 M
10(b)
Cloud computing
6 M
10(c)
Machine Learning System Model
6 M
10(d)
Data Warehouse.
6 M
More question papers from Database Management Systems