Ask
Login
TAGGED IN

Database Management Systems

Follow this tag to get notifications whenever a new post is added

ALL TAGS
6
votes
1
answer
117k
views
1
answer
Explain Total Participation and Partial Participation with example.
database management systems updated 18 months ago by binitamayekar ★ 6.0k
11
votes
2
answers
103k
views
2
answers
Construct an ER diagram for car insurance company that has a set of customers each of whom owns one or more cars. Each car has associated with it zero to any number of recorded accidents
database management systems updated 16 months ago by dragionro479 • 40
4
votes
1
answer
6.8k
views
1
answer
Consider a dependency diagram of relation R and normalise it upto third normal form.
database management systems updated 14 months ago by teamques10 ★ 53k
2
votes
1
answer
716
views
1
answer
Create and populate database using Data Definition Language (DDL) and DML Commands.
database management systems updated 13 months ago by binitamayekar ★ 6.0k
2
votes
1
answer
4.1k
views
1
answer
For the following dependencies find the candidate keys.
database management systems updated 13 months ago by binitamayekar ★ 6.0k
6
votes
1
answer
27k
views
1
answer
Explain log based recovery
database management systems updated 7.0 years ago by teamques10 ★ 53k
2
votes
1
answer
1.3k
views
1
answer
Convert the following tables to suitable Normal Form.
database management systems updated 13 months ago by binitamayekar ★ 6.0k
1
vote
1
answer
2.0k
views
1
answer
Explain Function in SQL.
database management systems updated 18 months ago by binitamayekar ★ 6.0k
2
votes
1
answer
5.5k
views
1
answer
Explain steps in query processing?
database management systems updated 17 months ago by teamques10 ★ 53k
5
votes
1
answer
36k
views
1
answer
What is Normalization? Explain 1NF, 2NF, 3NF and BCNF giving examples.
database management systems updated 16 months ago by sagarkolekar ★ 10k
3
votes
1
answer
3.2k
views
1
answer
Assume that two students are trying to register for a course in which there is only one open seat. What component of a database system prevents both students from being given that last seat?
database management systems updated 17 months ago by binitamayekar ★ 6.0k
3
votes
1
answer
16k
views
1
answer
List ACID properties. Explain usefulness of each.
database management systems updated 7.0 years ago by teamques10 ★ 53k
1
vote
1
answer
17k
views
1
answer
Consider the following employee database and write SQL queries for the following
database management systems updated 18 months ago by binitamayekar ★ 6.0k
33
votes
1
answer
441k
views
1
answer
Draw E-R diagram for Hospital management System.
database management systems updated 14 months ago by jaypanchal90968 • 20
7
votes
1
answer
123k
views
1
answer
Explain types of integrity constraints with example.
database management systems updated 18 months ago by binitamayekar ★ 6.0k
3
votes
1
answer
11k
views
1
answer
Draw the serializable graphs for the schedule S1 and S2 and state whether each schedule is...
database management systems updated 13 months ago by binitamayekar ★ 6.0k
1
vote
1
answer
8.1k
views
1
answer
Explain Query Optimization
database management systems updated 17 months ago by teamques10 ★ 53k
26
votes
1
answer
93k
views
1
answer
Describe overall architecture of DBMS with diagram.
database management systems updated 16 months ago by teamques10 ★ 53k
2
votes
1
answer
20k
views
1
answer
Construct and ER diagram and relational model for hospital
database management systems updated 16 months ago by sagarkolekar ★ 10k
6
votes
1
answer
80k
views
1
answer
Draw an ER diagram for university database consisting of four entities
database management systems updated 7 months ago by sagarkolekar ★ 10k
6
votes
1
answer
3.3k
views
1
answer
What is ER Diagrams in DBMS
database management systems updated 18 months ago by prakhar1144 ★ 5.0k
1
vote
1
answer
11k
views
1
answer
List all functional dependencies satisfied by the relation.
database management systems updated 17 months ago by pedsangini276 • 4.7k
2
votes
1
answer
1.0k
views
1
answer
Write SQL statements for Queries
database management systems updated 13 months ago by binitamayekar ★ 6.0k
0
votes
1
answer
23k
views
1
answer
Explain the terms total participation and partial participation with example.
database management systems updated 7.0 years ago by teamques10 ★ 53k
0
votes
1
answer
2.1k
views
1
answer
Explain Primary key, Strong entity set
database management systems updated 7.0 years ago by teamques10 ★ 53k
<prev • 206 results • page 1 of 9 • next >