Management to database systems questions.

Partial functional dependency describes dependency between attributes connected to each other.

Define the following concepts in databases systems:

1. Functional Dependency b)Composite Determinant c) Data Redundancy

List three(3) database management system software applications.

Mention three (3) control structures that are used for repetition in PHP.

Outline three (3) data definition language statements that are used to change database schemas.

1. Using the figure above ; write a program to create the simple HTML form with three (3) input fields, a text area, two radio buttons and a submit button as indicated in the diagram.
2. After the user fills the form and clicks the submit button, the data in the form is sent for processing to a PHP file named, “formData.php”. The data in the form is sent with the HTTP POST method and $_POST superglobal is used to collect the form data upon submission. Write a PHP script to implement formData.php by establishing a connection to MYSQL database server using brown as the username, green as the password, and localhost as the server name on which MYSQL is running. After the connection is established ; select a database on the server called companyDB and save the data received from the form in a table called employeeTable.

Use the tables given below that show instances of sailors, boats and allocations to answer the questions that follow;

Sailor:

Boat;

Allocation;

1. What is the result displayed after execution of the following query?

SELECT sailorName,gender,age,boatName FROM sailor s, allocation a, boat b WHERE a.sailorNo=s.sailorNo AND a.boatNo=b.boatNo AND age>=45;

2. Write a query to change Ibrahim`s name to Lincoln.
3. Write a query to remove all green boats.

Provide the name of the database concept whose description is given in each of the following:

1. An attribute(or a set of attributes)  that can have more than one value for a single value of a primary key.
2. A type of dependency that exists when there is an intermediate functional dependency.
3. The special variables used in PHP programming that cannot be changed during the entire execution of a program.

i.Define the following terms as related to electronic database and give two examples for each .

1. Database Model
2. Attribute
3. Database Management System
4. Super Key
5. Entity

ii.Describe ive areas where database are used

iii.Describe steps involved in database development process

iv.Why databases are implemented as part of the information systems?

1. What is normalization?
2. With examples , describe the following terms as related to normalization

1. Anomaly
2. Update anomaly
3. Insertion anomaly
4. Deletion anomaly