Computers and Technology, 14.04.2020 23:06 Ashtree519

Peter Chen developed ERDs in 1976. Since then Charles Bachman and James Martin have added some slight refinements to the basic ERD principles. You should use the Crow’s foot notation for your diagrams. Describe the use of keys in the database. Can you have more than one key? Explain your answer.

Answers: 3

Show answers

Answers

Answer from: Asantetaedog8934

Check the explanation

Explanation:

In RDBMS relational database, the keys play an essential role in making the database reliable and relational in which two or more relations (tables) can be divided into a range of relations with the use of diverse types of keys due to which the redundancy decreases and flexibility of data storage increases.

The following are the usage of keys in a database:

It helps in identifying a specific record that is present in the table.

It is used in minimizing the redundancy from the tables.

It is used in removing the multi-valued attributes from the relations.

it helps in connecting one table with others by using Foreign keys.

It is used in maintaining the uniqueness of the data stored in the database.

It helps in identifying the relationship between two or more tables.

Types of keys in a relational database:

PRIMARY KEY: It helps in identifying each record uniquely due to which the redundancy of data can be minimized.

FOREIGN KEY: It is a kind of referenced key that helps in making a relationship between two or more tables. It helps in fetching records by combining two or more tables with the help of different joins.

SUPER KEY: It is a combination of two or more keys that can be selected as primary. It may contain those columns which have repeated values.

COMPOUND KEY: It is a combination of those columns which may not be used independently as the identification of unique records but their combination does.

CANDIDATE KEY: It is a kind of a super key that does not contain repeated records. A primary key can be chosen from candidate keys.

Answer from: Quest

If ana decided to be against in prioritizing the task in her to do list, she will likely have insufficient time in doing the things in which she wouldn't be able to finish and in the same way, she won't be able to finish all of the task that she needed to do.

Answer from: Quest

1. entrepreneur.com

2. wikipedia

Another question on Computers and Technology

Computers and Technology, 21.06.2019 22:00

Determine which of the four levels of measurement (nominal, ordinal, interval, ratio) is most appropriate for the data below. internet speed levels of "fast comma " "medium comma " and "slow" choose the correct answer below. a. the ordinal level of measurement is most appropriate because the data can be ordered comma but differences left parenthesis obtained by subtraction right parenthesis cannot be found or are meaningless. nothing nothing nothing nothing nothing b. the interval level of measurement is most appropriate because the data can be ordered comma differences left parenthesis obtained by subtraction right parenthesis can be found and are meaningful comma and there is no natural starting point. c. the nominal level of measurement is most appropriate because the data cannot be ordered. nothing d. the ratio level of measurement is most appropriate because the data can be ordered comma differences left parenthesis obtained by subtraction right parenthesis can be found and are meaningful comma and there is a natural starting point.

Answers: 2

Answer

Computers and Technology, 22.06.2019 04:30

What kind of software users of all skill levels create web pages that include graphics, video, audio, animation, and other special effects? website authoring website software website publishing website editing

Answers: 1

Answer

Computers and Technology, 22.06.2019 07:30

Jasper and samantha are in a robotics competition. the guidelines state that the robots should be able to move a 10-gram weight at least 2 meters and turn in a circle. jasper and samantha have already built the robot. which step of the design process should they follow next to decide whether their robot meets the minimum criteria for the competition?

Answers: 1

Answer

Computers and Technology, 22.06.2019 21:30

Write a function named printfloatrepresentation(float number) that will print the floating point representation of a number using the format given below. (sign bit) exponent in binary (assumed bit).significandfor example if the number passed an argument is 71 yourprogram should print (0) 10000101 (1).00011100000000000000000similarly if the number passed to the function as argument is -71 the program should print (1) 10000101 (1).00011100000000000000000

Answers: 3

Answer

You know the right answer?

Peter Chen developed ERDs in 1976. Since then Charles Bachman and James Martin have added some sligh...

Questions