[go: up one dir, main page]
Scribd
Upload
77 views2 pages

What Is An Entity

An entity represents a table, while an attribute is a property of that entity. Relationships define associations between entities, with one-to-many relationships indicating that one entity can relate to multiple instances of another. A relational database consists of tables (relations) where each entry is unique and functionally dependent on a primary key, which is essential for proper database design.

Uploaded by

sethjpot
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
77 views2 pages

What Is An Entity

An entity represents a table, while an attribute is a property of that entity. Relationships define associations between entities, with one-to-many relationships indicating that one entity can relate to multiple instances of another. A relational database consists of tables (relations) where each entry is unique and functionally dependent on a primary key, which is essential for proper database design.

Uploaded by

sethjpot
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

What is an entity?

An entity is an object that represents a table. It can be many different items or things.

What is an attribute?

An attribute is a property of an entity. For example, if your entity/table is CUSTOMER, then


CUSTOMER_NAME would be an attribute.

What is a relationship? What is a one-to-many relationship?

A relationship is the association between entities. For example, at KimTay Pet Supplies there is an
association between customers and sales reps. A sales rep is associated with all of his or her
customers, and a customer is associated with his or her sales rep.

This is an example of a one-to-many relationship as the entity SALES_REP has a relationship to all of
his or her customers, but his or her customers only have a relationship to him. An attribute that
appears multiple times within other entities/tables and has a connection to many entities.

What is a repeating group?

A repeating group is when multiple entries are within a single location in a table. For example:

What is a relational database?

A rational database is a collection of tables which are formally known as relations.

What is a relation?

A relation isa two-dimensional table in which the entries in the table are single-valued (each location
in the table contains a single entry), each column has a distinct name, all values in the column match
this name, the order of the rows and columns is immaterial and each row contains unique values.
How do you qualify the name of a field, and when do you do this?

You have qualify a name when referencing the field in the DBMS. To qualify a field is to reference a
column by writing the table name and then the column separated by a period.

What does it mean for a column to be functionally dependent on another column?

It means a column has a direct relationship that determines the value of another columns or
columns.

What is a primary key? Why is a primary key required for proper database design?

A primary key is an attribute that other attributes are functionally dependent on and is also a unique
identifier for a table.

It needs to have two properties to be considered the primary key:

Property 1. All columns in the table are functionally dependent on A.


Property 2. No subcollections of the columns in A (assuming a is a collection of columns and not just
a single column) also has property 1.

A database at a college must support the following requirements:

For this database the functional dependencies are:

STUDENT_ID  STUDENT_FIRST_NAME, STUDENT_LAST_NAME, COURSE_ID, COURSE_DESC,


GRADE, STU_ADVISOR_ID, ADVISOR_NAME

COURSE_ID  COURSE DESC

STU_ADVISOR_ID  ADVISOR_NAME

COURSE_ID, STUDENT_ID  GRADE

You might also like