Dark Mode

Recent questions tagged relational-model

1 vote

2 answers

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, 2023

919 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, 2023

583 views

13 votes

5 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, 2023

by admin

8.4k 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

332 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

611 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

517 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 28, 2021

by LRU

317 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

573 views

2 votes

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

admin asked in Databases Apr 2, 2020

by admin

1.4k views

1 vote

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

admin asked in Databases Apr 1, 2020

by admin

896 views

1 vote

3 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

admin asked in Databases Apr 1, 2020

by admin

1.0k views

1 vote

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

admin asked in Databases Mar 31, 2020

by admin

1.6k views

2 votes

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

admin asked in Databases Mar 31, 2020

by admin

1.8k 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$ ...

admin asked in Databases Mar 30, 2020

by admin

912 views

Page:

1
2
3
4
next »

Recent questions tagged relational-model