DBMS #DOUBT ...

Will a single attribute key considered as a prime attribute as well?I know If it is a compound key like (ABC) then my prime attribute set would be {A,B,C,AB,BC,AC}But if ...

Mrityudoot

306 views

Mrityudoot asked Jul 28, 2023

Databases
functional-dependency
databases
database-normalization

+ –

2 votes

2 answers

atulcse asked Jan 22, 2022

619 views

normalization - DBMS
If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency?

If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency?

atulcse

619 views

atulcse asked Jan 22, 2022

Databases
databases
database-normalization

+ –

0 votes

0 answers

SidX asked Sep 26, 2021

575 views

DBMS, School Assignment
Consider an EMPLOYEE file with 10000 records where each record is of size 80 bytes. The file is sorted on employee number (15 bytes long), which is the primary key. Assuming un-spanned organization, block size of 512 bytes and block pointer size of 5 ... for retrieving an employee record based on employee number if (i) No index is used (ii) Multi-level primary index is used.

Consider an EMPLOYEE file with 10000 records where each record is of size 80 bytes. The file is sorted on employee number (15 byteslong), which is the primary key. Assumi...

SidX

575 views

SidX asked Sep 26, 2021

Databases
databases
database-normalization

+ –

1 votes

2 answers

pritam946 asked May 10, 2019

1,141 views

dbms normalization - 2nf/bcnf query
Consider the following relational schemes: R(A, B, C, D, E, F) and S(A, B, C) with in the following functional dependencies: I. AB --> C II. C --> ABDE III. ADE --> F Assume {A,B} is the key for both schemes. Which of the ... C is the relation for the S table, which satisfies BCNF properties. (So S is in BCNF) Please let me know if it is correct or not.

Consider the following relational schemes: R(A, B, C, D, E, F) and S(A, B, C) with in the following functional dependencies:I. AB CII. C ABDEIII. ADE FAssume {A,B} ...

pritam946

1.1k views

pritam946 asked May 10, 2019

Databases
database-normalization
databases

+ –

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

0 reply

Please log in or register to add a comment.

Please log in or register to answer this question.

1 Answer

0 reply

Please log in or register to add a comment.

Related questions

0

0