Ask
Login
TAGGED IN

Database Management Systems

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

ALL TAGS
5
votes
1
answer
7.6k
views
1
answer
Consider a dependency diagram of relation R and normalise it upto third normal form.
database management systems updated 2.1 years ago by teamques10 ★ 64k
10
votes
1
answer
132k
views
1
answer
Explain Total Participation and Partial Participation with example.
database management systems updated 2.4 years ago by binitamayekar ★ 6.4k
12
votes
2
answers
132k
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 2.3 years ago by dragionro479 • 40
3
votes
1
answer
24k
views
1
answer
Construct and ER diagram and relational model for hospital
database management systems updated 2.3 years ago by sagarkolekar ★ 11k
2
votes
1
answer
1.3k
views
1
answer
Create and populate database using Data Definition Language (DDL) and DML Commands.
database management systems updated 2.1 years ago by binitamayekar ★ 6.4k
2
votes
1
answer
5.5k
views
1
answer
For the following dependencies find the candidate keys.
database management systems updated 2.1 years ago by binitamayekar ★ 6.4k
6
votes
1
answer
29k
views
1
answer
Explain log based recovery
database management systems updated 7.9 years ago by teamques10 ★ 64k
2
votes
1
answer
1.9k
views
1
answer
Convert the following tables to suitable Normal Form.
database management systems updated 2.1 years ago by binitamayekar ★ 6.4k
1
vote
1
answer
2.4k
views
1
answer
Explain Function in SQL.
database management systems updated 2.4 years ago by binitamayekar ★ 6.4k
2
votes
1
answer
6.0k
views
1
answer
Explain steps in query processing?
database management systems updated 2.4 years ago by teamques10 ★ 64k
5
votes
1
answer
39k
views
1
answer
What is Normalization? Explain 1NF, 2NF, 3NF and BCNF giving examples.
database management systems updated 2.3 years ago by sagarkolekar ★ 11k
3
votes
1
answer
4.1k
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 2.4 years ago by binitamayekar ★ 6.4k
3
votes
1
answer
18k
views
1
answer
List ACID properties. Explain usefulness of each.
database management systems updated 7.9 years ago by teamques10 ★ 64k
1
vote
1
answer
21k
views
1
answer
Consider the following employee database and write SQL queries for the following
database management systems updated 2.4 years ago by binitamayekar ★ 6.4k
35
votes
1
answer
567k
views
1
answer
Draw E-R diagram for Hospital management System.
database management systems updated 2.1 years ago by jaypanchal90968 • 20
7
votes
1
answer
128k
views
1
answer
Explain types of integrity constraints with example.
database management systems updated 2.4 years ago by binitamayekar ★ 6.4k
3
votes
1
answer
20k
views
1
answer
Draw the serializable graphs for the schedule S1 and S2 and state whether each schedule is...
database management systems updated 2.1 years ago by binitamayekar ★ 6.4k
1
vote
1
answer
8.9k
views
1
answer
Explain Query Optimization
database management systems updated 2.4 years ago by teamques10 ★ 64k
28
votes
1
answer
113k
views
1
answer
Describe overall architecture of DBMS with diagram.
database management systems updated 2.3 years ago by teamques10 ★ 64k
6
votes
1
answer
90k
views
1
answer
Draw an ER diagram for university database consisting of four entities
database management systems updated 18 months ago by sagarkolekar ★ 11k
6
votes
1
answer
3.8k
views
1
answer
What is ER Diagrams in DBMS
database management systems updated 2.5 years ago by prakhar1144 ★ 5.0k
2
votes
1
answer
15k
views
1
answer
List all functional dependencies satisfied by the relation.
database management systems updated 2.3 years ago by pedsangini276 • 4.7k
2
votes
1
answer
1.7k
views
1
answer
Write SQL statements for Queries
database management systems updated 2.1 years ago by binitamayekar ★ 6.4k
0
votes
1
answer
24k
views
1
answer
Explain the terms total participation and partial participation with example.
database management systems updated 7.9 years ago by teamques10 ★ 64k
0
votes
1
answer
2.3k
views
1
answer
Explain Primary key, Strong entity set
database management systems updated 7.9 years ago by teamques10 ★ 64k
<prev • 206 results • page 1 of 9 • next >