Dark Mode

Recent questions tagged relational-model

1 vote

1 answer

1

Database ER model
An ER diagram is having two strong entities E1 and E2. The relationship between the entities ‘R’ is having partial participation from E1 side and total participation from E2 side with 1:1 cardinality. The entities E1 and E2 are having one multivalued attribute each. How many numbers of relations are required to represent the ER model into the relational model?

Ashutosh_17 asked in Databases Apr 13

175 views

1 vote

1 answer

2

GO Classes 2023 | IIITH Mock Test 1 | Question: 17
Consider the following ER diagram : borrower mapping cardinality is many-to-many. While converting the ER diagram into a relational DBMS model, the relationship set borrower is converted into a relation borrower(cust_id, loan_id, ... , what is the primary key of borrower ? cust_id loan_id (cust_id, loan_id) (cust_id, loan_id, access_date)

GO Classes asked in Databases Mar 26

144 views

3 votes

3 answers

3

GATE CSE 2023 | Question: 6
Which one of the options given below refers to the degree (or arity) of a relation in relational database systems? Number of attributes of its relation schema. Number of tuples stored in the relation. Number of entries in the relation. Number of distinct domains of its relation schema.

admin asked in Databases Feb 15

by admin

1.5k views

0 votes

0 answers

4

Databases
How to identify many to many relationship. Can R2 be one to one.

Overflow04 asked in Databases Nov 29, 2022

158 views

0 votes

1 answer

5

Normalisation
Consider a relation R with more than two attributes. Let A and B are sets of attributes from R and A$\cap$B = $\phi$. Functional dependency A → B holds on R. Which one of the following can be a correct possible situation for R? A and B contain prime and non-prime ... do we need to assume that all the functional dependencies holding on R are of type A → B such that A$\cap$B = $\phi$?

Chaitanya Kale asked in Databases Nov 1, 2022

by Chaitanya Kale

326 views

0 votes

2 answers

6

Made easy Test Series 2022
I am getting ans 6 and given ans is 8

SKMAKM asked in Databases Aug 30, 2022

by SKMAKM

325 views

2 votes

1 answer

7

GATE ACADEMY TEST SERIES
Under a relational database if table A has a foreign key constraint referencing to another table B, then Each tuple in A is related to zero or one tuple of B. Each tuple in A is related to exactly one tuple of B. Each tuple of A is related to zero or more tuple of B. None of these.

LRU asked in Databases Sep 29, 2021

by LRU

215 views

1 vote

1 answer

8

UGC NET CSE | October 2020 | Part 2 | Question: 67
Match $\text{List I}$ with $\text{List II}$ Choose the correct answer from the options given below: $A-II, B-IV, C-III, D-I$ $A-IV, B-I, C-II, D-III$ $A-II, B-I, C-IV, D-III$ $A-III, B-IV, C-I, D-II$

go_editor asked in Databases Nov 20, 2020

467 views

1 vote

5 answers

9

NIELIT 2016 MAR Scientist C - Section C: 5
A primary key, if combined with a foreign key creates parent child relationship between the tables that connect them many-to-many relationship between the tables that connect them network model between the tables that connect them none of these

Lakshman Bhaiya asked in Databases Apr 2, 2020

by Lakshman Bhaiya

899 views

0 votes

1 answer

10

NIELIT 2017 OCT Scientific Assistant A (CS) - Section B: 14
E-R model uses this symbol to represent weak entity set? Dotted rectangle Diamond Doubly outlined rectangle None of these

Lakshman Bhaiya asked in Databases Apr 1, 2020

by Lakshman Bhaiya

660 views

0 votes

2 answers

11

NIELIT 2017 OCT Scientific Assistant A (CS) - Section B: 21
What is the modality of relationship, if there is no explicit need for relationship to occur? Zero Two Three One

Lakshman Bhaiya asked in Databases Apr 1, 2020

by Lakshman Bhaiya

665 views

0 votes

2 answers

12

NIELIT 2016 MAR Scientist B - Section C: 40
In a relational Schema, each tuple is divided into fields called relations domains queries none of these

Lakshman Bhaiya asked in Databases Mar 31, 2020

by Lakshman Bhaiya

1.1k views

1 vote

1 answer

13

NIELIT 2016 MAR Scientist B - Section C: 41
The employee salary should not be greater than Rs.$2000$. This is integrity constraint referential constraint over-defined constraint feasible constraint

Lakshman Bhaiya asked in Databases Mar 31, 2020

by Lakshman Bhaiya

1.2k views

2 votes

2 answers

14

NIELIT 2017 July Scientist B (IT) - Section B: 19
If $R$ is a relation in Relational Data Model and $A_1,A_2,\dots A_n$ are the attributes of relation $R$, what is the cardinality of $R$ ...

Lakshman Bhaiya asked in Databases Mar 30, 2020

by Lakshman Bhaiya

507 views

0 votes

1 answer

15

NIELIT 2017 July Scientist B (IT) - Section B: 53
Related fields in a database are grouped to form a data file data record menu bank

Lakshman Bhaiya asked in Databases Mar 30, 2020

by Lakshman Bhaiya

838 views

1 vote

1 answer

16

NIELIT 2017 DEC Scientist B - Section B: 34
The condition for total participation of entity in a relationship is _______. Maximum cardinality should be one Minimum cardinality should be one Minimum cardinality should be zero None of the options

Lakshman Bhaiya asked in Databases Mar 30, 2020

by Lakshman Bhaiya

1.8k views

3 votes

2 answers

17

UGC NET CSE | June 2019 | Part 2 | Question: 32
Which of the following features is supported in the rational database model? Complex data-types Multivalued attributes Associations with multiplicities Generalization relationships

Arjun asked in Databases Jul 2, 2019

by Arjun

3.6k views

1 vote

1 answer

18

Doubt
Do we need to find closure of functional dependencies of original relation to check whether the decomposed tables are in 2NF . I know that we have to do the above process for 3NF and BCNF . If yes , please give a example where we need to do it

ashunimbz asked in Databases Mar 30, 2019

335 views

0 votes

1 answer

19

DBMS Korth Edition 6 Exercise 3 Question 24 (Page No. 111)
Consider the query: with dept total (dept name, value) as (select dept name, sum(salary) from instructor group by dept name), dept total avg(value) as (select avg(value) from dept total) select dept name from dept total, dept total avg where dept total.value >= dept total avg.value; Rewrite this query without using the with construct.

ajaysoni1924 asked in Databases Mar 30, 2019

by ajaysoni1924

1.2k views

0 votes

0 answers

20

DBMS Korth Edition 6 Exercise 3 Question 23 (Page No. 111)
Consider the query: select course id, semester, year, sec id, avg (tot cred) from takes natural join student where year = 2009 group by course id, semester, year, sec id having count (ID) >= 2; Explain why joining section as well in the from clause would not change the result.

ajaysoni1924 asked in Databases Mar 30, 2019

by ajaysoni1924

601 views

Page:

1
2
3
4
next »

Recent questions tagged relational-model