Project Scope
There is no duplicate data.
De normalization is the process of improving the speed for the read-based performance of the Database structure and it is used to decrease the some problem in the Database queries with the help of adding some redundant copies of information as well as reduce the schema layer of normalization.
1.
2.
3a (i)
3a (ii)
3a (iii)
3a (iv)
3b
3c.
4.
In azwh_diagnosis_aetiology table, the id has the PRIMARY and NOT NULL constraints.
In azwh_patients table, the id has the PRIMARY and NOT NULL constraints and animal_id has the NOT NULL constraints.
In azwh_diagnosis_anatomical table, id has the PRIMARY and NOT NULL constraints.
In azwh_breeds table, id has the NOT NULL and PRIMARY constraints and azwh_accession_id has the NOT NULL constraints.
In azwh_diagnosis_categories table, id has the NOT NULL and PRIMARY constraints.
In azwh_types table, id has the PRIMARY and NOT NULL constraints and azwh_accessions_id has the NOT NULL constraints.
In Works_on table, essn has the PRIMARY and NOT NULL constraints and pno also has the PRIMARY and NOT NULL constraints.
Normal forms are 1NF, 2NF, 3NF and BCNF.
1NF
It contains only single value, because it cannot hold multiple values.
For example
pname |
pnumber |
plocation |
dnum |
Computerization |
10 |
Stafford |
4 |
Reorganization |
20 |
Houston |
1 |
New benefits |
30 |
Stafford |
4 |
Operating Systems |
61 |
Jacksonville |
6 |
Database Systems |
62 |
Birmingham |
6 |
2NF
2NF is contain the major condition is it never dependent with the non-primitive attribute in the table and it must be use the first normal form table.
For example
pname |
pnumber |
plocation |
dnum |
Computerization |
10 |
Stafford |
4 |
Reorganization |
20 |
Houston |
1 |
New benefits |
30 |
Stafford |
4 |
Operating Systems |
61 |
Jacksonville |
6 |
Database Systems |
62 |
Birmingham |
6 |
pname |
pnumber |
Computerization |
10 |
Reorganization |
20 |
New benefits |
30 |
Operating Systems |
61 |
Database Systems |
62 |
pname |
plocation |
dnum |
Computerization |
Stafford |
4 |
Reorganization |
Houston |
1 |
New benefits |
Stafford |
4 |
Operating Systems |
Jacksonville |
6 |
Database Systems |
Birmingham |
6 |
3NF
The main process of 3NF is minimizing the transitive overflow as well as increases the data connectivity.
For example
pname |
pnumber |
plocation |
Computerization |
10 |
Stafford |
Reorganization |
20 |
Houston |
New benefits |
30 |
Stafford |
Operating Systems |
61 |
Jacksonville |
Database Systems |
62 |
Birmingham |
pname |
dnum |
Computerization |
4 |
Reorganization |
1 |
New benefits |
4 |
Operating Systems |
6 |
Database Systems |
6 |
pname |
pnumber |
plocation |
Computerization |
10 |
Stafford |
Reorganization |
20 |
Houston |
New benefits |
30 |
Stafford |
Operating Systems |
61 |
Jacksonville |
Database Systems |
62 |
Birmingham |
Index means data is stored in the form of tuples. Each and every tuples contains a key field, which is used for identifying the information in the unique way. It is one of the important data structure approach used to access the information based on some attribute on indexing has been done in an efficient manner.
The below listed diagram comprises of all the Crow’s Foot notation. This diagram contains boxes and are denoted as entities, then the lines between the boxes denotes the relationships. At the ends of these lines, the cardinality of the relationship is represented in different shapes.
The below diagram represents the Relational Schema of My Computer Specialist Pty Ltd (MCS).
Stored procedure is a collection of SQL command combined together with the assigned name. And it is saved in the RDBMS as a team. So it can provide the reuse as well as sharing of information by the multiple users in the data structure. The given database procedures are listed below.