What do you mean by an entity

Assignment Help Computer Engineering

Reference no: EM1328757

1. What is an entity? An attribute?

2. What is a one-to-many relationship? Give two examples of entities that have one-to-many relationships.

3. What is a DBMS?

4. How is it possible to get more information from the same amount of data though using a database approach as opposed to a file approach?

5. What is a DBA? What kinds of things does a DBA do in a database environment?

6. How does consistency result from controlling or eliminating redundancy?

7.What is meant by security? What does the DBMS have to do with security?

8. How can the size of a DBMS be one of its disadvantage?

9. Why can a failure in a database environment be more serious than one in a file environment?

10. What is a relational database ?

11. How is the term attribute used in the relational model? What is a more common
of the name for it?

12. What does it mean to quality the name of a field? How is this done?

13. Give an example of an attribute, A, and another attribute, B, such that B is functionally dependent on A. Give an example of an attribute, C, and an attribute, D, such that D is not functionally dependent on C.

14. Define candidate key.

15. Define second normal form. What types of problems are encountered in table that are in second normal form.

16. Consider a student table containing a student's number, student's name, student's major department, student advisor's number, student advisor's name, student advisor's office number, student advisor's phone number, student's number of credits, and student's class standing (freshman, sophomore, and so on). List the functional dependencies that exist, along with the assumptions that would support these dependencies.

17. Convert the following table to an equivalent collection of tables that is in 3NF.
PATIENT (HOUSEHOLD_NUMBER, HOUSEHOLD_NAME, HOUSEHOLD_STREET,
HOUSEHOLD_CITY, HOUSEHOLD_STATE, HOUSEHOLD_ZIP,
BALANCE, PATIENT _NUMBER, PATIENT _NAME
(SERVICE_CODE, SERVICE_DESCRIPTION, SERVICE_FEE,
SERVICE_DATE))
This is a table concerning information about patients of a dentist. Each patient belongs to a household. The head of the household is designated as HH in the table. The following dependencies exist in the PATIENT table:
PATIENT_NUMBERà HOUSEHOLD_NUMBER, HOUSEHOLD_NAME,
HOUSEHOLD_STREET, HOUSEHOLD_CITY, HOUSEHOLD_STATE,
HOUSEHOLD_ZIP, BALANCE, PATIENT _NAME
HOUSEHOLD_NUMBERà HOUSEHOLD_NAME, HOUSEHOLD_STREET,
HOUSEHOLD_CITY, HOUSEHOLD_STATE, HOUSEHOLD_ZIP, BALANCE
SERVICE_CODEà SERVICE_DESCRIPTION, SERVICE_FEE
PATIENT_NUMBER, SERVICE_CODEà SERVICE_DATE

18. Using your knowledge of a college environment, determine the functional dependencies that exist in the following table. After these have been determined, covert this table to an equivalent collection of tables that are in 3NF.
STUDENT (STUDENT_NUMBER, STUDENT_NAME, NUMBER_CREDITS, ADVISOR_NUMBER, ADVISOR_NAME, DEPTNUMB, DEPTNAME, (COURSE_NUMBER, COURSE_DESCRIPTION, COURSE_TERM, GRADE))

Reference no: EM1328757

Questions Cloud

The remedies for team dysfunction : How would you apply the remedies for team dysfunction differently on temporary teams?

Strategies adopt to enhance relationships with co-workers : Propose and discuss at least three strategies leaders should adopt to enhance their relationships with superiors, co-workers and subordinates.

Presidential powers influencing crime control policy : Define and discuss the Presidential powers used to influence crime control policy and what powers the President can use as well as the sources of those powers.

Knowledge of the product''s characteristcs : Knowledge of the product's characteristics and distribution - Describe how knowledge of the product's characteristcs can be used to specify or alter the way in which the products are distributed.

What do you mean by an entity : How is it possible to get more information from the equal amount of data though using a database approach as opposed to a file approach.

The five major environmental variables : What are the five major environmental variables that focus on the future interest of the firm?

Maximum payment to preferred stockholders : Kuhns Corp. has 200,000 shares of preferred stock outstanding that is cumulative. The dividend is $6.50 per share and hasn't been paid for 3 years. If Kuhns earned $3 million this year, what could be maximum payment to preferred stockholders on p..

Role of three levels of government legislation : Define and discuss how the roles of the three levels of government legislation differ in the criminal justice policy process.

Importance of managing systems and processes : Cost benefit analysis - Clearly explain the importance of managing systems and processes in order to achieve effective and efficient production and operations.

User Account

All Pages