Management to database systems UE Past Papers Questions.

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

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

(Error incomplete)

Answer / Solution

UNSOLVED

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.

Answer / Solution

UNSOLVED

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

Answer / Solution

UNSOLVED

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

Answer / Solution

UNSOLVED

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

Answer / Solution

UNSOLVED