Management to database systems questions.

Make use of functional dependencies given below to answers the questions thereafter:

Student StudentName, StudentIDAge, CourseIDCourseName, (StudentID, CourseID)Grade, GradeGradePoint.

(Error incomplete)

1. List and briefly explain the types of data anomalies that could arise from relations that are generated directly from user views.

The table below contains information about employees in a company in which each employee has a department associated with him/her as well as project s/he participates in. Use it to give an example of each type of data anomaly described above.

2. Define normalization and state its significance in database modelling.
3. Apply the rules of normalization to the table in (i) above to produce a set of well-designed third normal form (3NF) relations. Identify all the primary, and foreign keys in your 3NF relations.

phpMyadmin is a remote login utility used to connect to Mysql databases.

The WHERE clause in the SQL SELECT statement is used to sort the result of the query.

Variables in PHP begin with a dollar symbol ($).

DESCRIBE command is used in SQL to display the list of all available tables.

CHAR is a data type in MYSQL that accepts variable-length of text data up to 255 characters.

Foreign key values must match a candidate key value of some tuple in the home relation.

% is a special character used in SQL statement to match a pattern of any single character.

define(‘size’,25); is a statement in PHP that creates a variable and assigns it a value of 25.