The Entity Relationship Data Model ERD

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

This is a entity relationship data model (ERD). In the entity relationship data model have are animal, owner, prescription drugs, veterinary doctor, appointments and branch Petcare, it is for the important classification. So there has six classification of the Petcare database. In "Branch Petcare" entity, it has one relationships classification. Have are relationship from "Branch Petcare" entity to "Veterinary Doctor" entity. The "Branch Petcare" has "Address", "Petcare ID", "Branch Name", "PhoneNo", "EphoneNO" and OPtimes. So has are six fine classification in it. And the primary key is the "Petcare ID".

P.1

In "Veterinary Doctor" entity, it has two relationships classification. First one relationship is from "Appointments" entity to "Veterinary Doctor" entity, the other one relationship is from "Veterinary Doctor" entity to "Animal" entity. The "Veterinary Doctor" has "Doctor Name", "Address", "HphoneNO", "MphoneNO", "Specialise Animal", "Doctor ID" and "Branch With". So has are seven fine classification in it. And the primary key is the "Doctor ID".

In "Appointments" entity, it has one relationships classification. Have are relationship from "Appointments" entity to "Veterinary Doctor" entity. The "Appointments" has "Appointments ID", "Times", "Day", "Doctor With", "Diagnosis" and "Charge". So has are six fine classification in it. And the primary key is the "Appointments ID".

In "Owner" entity, it has one relationships classification. Have are relationship from "Owner" entity to "Animal" entity. The "Owner" has "Owner ID", "Owner Name", "Address", "HphoneNO" and the "MphoneNO". So has are five fine classification in it. And the primary key is the "Owner ID".

In "Animal" entity, it has three relationships classification. First one relationship is from "Animal" entity to "Owner" entity, the other one relationship is from "Animal" entity to "Prescription Drugs" entity. The last one relationship is from "Animal" entity to "Veterinary Doctor" entity. The "Animal" has "Classification", "Sex", "Age", "Animal Name" and "Animal ID". So has are five fine classification in it. And the primary key is the "Animal ID".

In "Prescription Drugs" entity, it has one relationships classification. Have are relationship from "Prescription Drugs" entity to "Animal" entity. The "Prescription Drugs" has "Prescription ID", "Drug Name", "Record Day" and "Medication Cost". So has are four fine classification in it. And the primary key is the "Prescription ID".

P.2

Task 2

Produce the resulting normalised tables clearly indicating the primary and foreign keys. (20 Marks)

Primary and Foreign keys

(A2)

This is a primary and foreign keys for the database. Database need primary key and foreign key to normalised the table. It is because primary keys and foreign keys is so important in the database, they have are relationship to relationship connection search in the database.

Primary key mean an attribute, in the database fine classification information data only have one primary key only. So the primary key in the database influence coverage is very big, so set the primary key must careful and discreet.

Foreign key mean an attribute, in the database fine classification information data can have more than one foreign key. So the foreign key in the database always have two to three, the foreign key in the database influence coverage is small than primary key, but it too important in the database.

P.3

In the "Branch Petcare" entity, it has one primary key and five foreign key. The primary key is

"Petcare ID". The foreign key is "Doctor ID", "Appointments ID", "Owner ID", "Animal ID" and

"Prescription ID". The "Branch Petcare" fine classification information have are "Branch Name", "Address", "OPtimes", "PhoneNO' and "EphoneNO", so it have are five fine classification in the "Branch Petcare" entity. So this entity is so much important in the this database.

In the "Veterinary Doctor" entity, it has one primary key and two foreign key. The primary key is

"Doctor ID". The foreign key is "Petcare ID" and "Appointments ID". The "Veterinary Doctor" fine classification information have are "Doctor Name", "Address", "MhoneNO", "HphoneNO", "Specialise Animal" and "Branch With", so it have are six fine classification in the "Veterinary Doctor" entity.

In the "Appointments" entity, it has one primary key and one foreign key. The primary key is

"Appointments ID" and the foreign key is "Owner ID". The "Appointments" fine classification information have are "Times", "Day", "Doctor With", "Diagnosis" and "Charge", so it have are five fine classification in the "Appointments" entity.

In the "Owner" entity, it has one primary and one foreign key. The primary is "Owner ID" and the foreign key is "Animal ID". The "Owner" fine classification information have are "Owner Name", "Address", "HphoneNO" and "MphoneNO", so it have are four fine classification in the "Owner" entity.

In the "Animal" entity, it has one primary and two foreign key. The primary is "Animal ID", and the

foreign key is "Owner ID" and "Prescription ID". The "Animal" fine classification information have are

"Classification", "Sex", "Age" and "Animal Name", it has four fine classification in the "Animal" entity.

In the "Prescription Drugs" entity, it has one primary and two foreign key. The primary is "Prescription ID" and the foreign key is "Animal ID". The "Prescription Drugs" fine classification information have are

"Drug Name", "Record Day" and "Medication Cost", so it have are three fine classification in the "Prescription Drugs". P.4

Task 3

Using a Database Management System (DBMS) of your choice, set-up all of the above normalised tables, and populate them with well-designed test data (minimum 5 records per table). Provide printouts of all tables. (20 Marks)

Normalised Tables : First Normal Form

The "Branch Petcare" entity table is ready to normalisation. The primary key set to "Petcare ID".

The "Veterinary Doctor" entity table is ready to normalisation. The primary key set to "Doctor ID".

The "Prescription Drugs" entity table is ready to normalisation. The primary key set to "Prescription ID".

P.5

The "Appointments" entity table is ready to normalisation. The primary key set to "Appointments ID".

The "Animal" entity table is ready to normalisation. The primary key set to "Animal ID".

The "Owner" entity table is ready to normalisation. The primary key set to "Owner ID"

So the six tables is ready to normalisation. The normalisation function is change the no relationship

table to has are relationship connection. In the database, information has relationship is so very important. So this six entity table finish the normalisation, they must has relationship to other table

connection. And the this part is very important, in the this process procedure has wrong, the database

will have are some error and the database will do work. So must careful and discreet.

P.6

Normalised Tables : Second Normal Form

The "Branch Petcare" done second normal form can component are two classification table. It

is are "Branch Petcare" and "Branch Petcare _Detail". In the "Branch Petcare" the primary key is

"Petcare ID", fine classification information have "Doctor ID", "Appointments ID", "Owner ID", "Animal ID" and "Prescription ID". In the "Branch Petcare _Detail" the primary key is "Branch Name", fine classification information have "Petcare ID", "Address", "OPtimes", "PhoneNO' and "EphoneNO".

The "Veterinary Doctor" done second normal form can component are two classification table. It is

are "Veterinary Doctor" and "Veterinary Doctor _Detail". In the "Veterinary Doctor" the primary key is

"Doctor ID", fine classification information have "Petcare ID" and "Appointments ID". In the "Veterinary Doctor _Detail" primary is "Doctor Name", fine classification information have "Doctor ID", "Address", "MhoneNO", "HphoneNO", "Specialise Animal" and "Branch With".

P.7

The "Owner" done second normal form can component are two classification table. It is are

"Owner" and "Owner _Detail". In the "Owner" the primary key is "Owner ID", fine classification information have "Animal ID". In the "Owner _Detail" the primary key is "Owner Name", fine classification information have "Owner ID", "Address", "HphoneNO" and "MphoneNO".

The "Animal done second normal form can component are two classification table. It is are "Animal"

And "Animal _Detail". In the "Animal" the primary key is "Animal ID", fine classification information have

"Owner ID" and "Prescription ID". In the "Animal _Detail" the primary key is "Animal Name", fine classification information have "Animal ID", "Classification", "Sex" and "Age".

P.8

The "Appointments" done second normal form can component are two classification table. It is are

"Appointments" and "Appointments _Detail". In the "Appointments" the primary key is "Appointments ID", fine classification information have "Owner ID". In the "Appointments _Detail" the primary key is

"Doctor With", fine classification information have "Appointments _Detail", "Times", "Day", "Diagnosis"

And "Charge".

The "Prescription Drugs" done second normal form can component are two classification table.

It is are "Prescription Drugs" and "Prescription Drugs _D". In the "Prescription Drugs" the primary key

is "Prescription ID", fine classification information have "Animal ID". In the "Prescription Drugs _D"

the primary key is "Drug Name", fine classification information have "Prescription ID", "Record Day"

and "Medication Cost".

P.9

Normalised Tables : Third Normal Form

The "Branch Petcare" done third normal form. At last it can component are three classification tables. Among has two classification tables identical with done second normal. So done third normal form has

are new one classification tables. The new one classification tables is "Branch Petcare _Doctor". In the

"Branch Petcare _Doctor" the primary key is "Doctor ID", fine classification information have "Branch Name".

To summarize, the "Branch Petcare" can normal are three classification tables. Every layered can detail over detail. So "Branch Petcare" classification tables and there six fine classification information

must has are relationship with "Branch Petcare _Detail" classification tables and there six fine classification information. At last, the "Branch Petcare _Detail" classification tables and here six fine classification information must has are relationship with "Branch Petcare _Doctor" classification tables and here two fine classification information. So in the "Branch Petcare" normalised form, to summarize has are three primary keys and total has are fourteen fine classification information. The primary key is "Petcare ID", "Branch Name" and "Doctor ID".

P.10

The "Veterinary Doctor" done third normal form. At last it can component are three classification tables. Among has two classification tables identical with done second normal. So done third normal form has are new one classification tables. The new one classification table is "Veterinary Doctor _CM". In the"Veterinary Doctor_ CM" the primary key is "MphoneNO", fine classification information have "Doctor Name", "HphoneNO" and "Address".

To summarize, the "Veterinary Doctor" can normal are three classification tables. Every layered can detail over detail. So "Veterinary Doctor" classification tables and there three fine classification information must has are relationship with "Veterinary Doctor _Detail" classification tables and there four fine classification information. At last, the "Veterinary Doctor _Detail" classification tables and here four fine classification information must has are relationship with "Veterinary Doctor _CM" classification tables and here four fine classification information. So in the "Veterinary Doctor" normalised form, to summarize has are three primary keys and total has are eleven fine classification information. The primary key is "Doctor ID", "Doctor Name" and "MphoneNO".

P.11

The "Owner" done third normal form. At last it can component are three classification tables. Among has two classification tables identical with done second normal. So done third normal form has are new one classification tables. The new one classification table is "Owner _Reserve". In the

"Owner _Reserve" the primary key is "Appointments ID", fine classification information have "Owner Name".

To summarize, the "Owner" can normal are three classification tables. Every layered can detail over detail. So "Owner" classification tables and there has two fine classification information must has are relationship with "Owner _Detail" classification tables and there five fine classification information. At last, the "Owner _Detail" classification tables and here five fine classification information must has are relationship with "Owner _Reserve" classification tables and here two fine classification information.

So in the "Owner" normalised form, to summarize has are three primary keys and total has are nine fine classification information. The primary key is "Owner ID", "Owner Name" and "Appointments ID".

P.12

The "Animal" done third normal form. At last it can component are three classification tables. Among has two classification tables identical with done second normal. So done third normal form has are new one classification tables. The new one classification table is "Animal _Treat". In the "Animal _treat" the primary key is "Classification", fine classification information have "Animal Name".

To summarize, the "Animal" can normal are three classification tables. Every layered can detail over detail. So "Animal" classification tables and there three fine classification information must has are relationship with "Animal _Detail" classification tables and there four fine classification information. At last, the "Animal _Detail" classification tables and here four fine classification information must has are relationship with "Animal _Treat" classification tables and here two fine classification information.

So in the "Animal" normalised form, to summarize has are three primary keys and total has are nine fine classification information. The primary key is "Animal ID", "Animal Name" and "Classification".

P.13

The "Appointments" done third normal form. At last it can component are three classification tables. Among has two classification tables identical with done second normal. So done third normal form has are new one classification tables. The new one classification table is "Appointments _Result". In the "Appointments _Result" the primary key is "Animal Name", fine classification information have "Doctor With", "Diagnosis" and "Charge".

To summarize, the "Appointments" can normal are three classification tables. Every layered can detail over detail. So "Appointments" classification tables and there has two fine classification information must has are relationship with "Appointments _Detail" classification tables and there four fine classification information. At last, the "Appointments _Detail" classification tables and here four fine classification information must has are relationship with "Appointments _Result" classification tables and here four fine classification information.

So in the "Appointments" normalised form, to summarize has are three primary keys and total has are ten fine classification information. The primary key is "Appointments ID", "Doctor With" and "Animal Name".

P.14

The "Prescription Drugs" done third normal form. At last it can component are three classification tables. Among has two classification tables identical with done second normal. So done third normal form has are new one classification tables. The new one classification table is "Prescription Drugs _R". In the "Prescription Drugs _R" the primary key is "Doctor ID", fine classification information have

"Drug Name".

To summarize, the "Prescription Drugs" can normal are three classification tables. Every layered can detail over detail. So "Prescription Drugs" classification tables and there has two fine classification information must has are relationship with "Prescription Drugs _D" classification tables and there four fine classification information. At last, the "Prescription Drugs _D" classification tables and here four fine classification information must has are relationship with "Prescription Drugs _R" classification tables and here two fine classification information.

So in the "Prescription Drugs" normalised form, to summarize has are three primary keys and total has are nine fine classification information. The primary key is "Prescription ID", "Drug Name" and "Doctor ID".

P.16

The Normalised Tables in the Database Management System (DBMS)

So has are eighteen primary key and has are sixteen one fine classification information. P.17

Test Data (minimum 5 records per table) in the Database Management System (DBMS)

The "Branch Petcare" table :

The "Branch Petcare _Detail" table :

The "Branch Petcare _Doctor" table :

P.17

The "Veterinary Doctor" table :

The "Veterinary Doctor _Detail" table :

The "Veterinary Doctor _CM" table :

P.18

The "Owner" table :

The "Owner _Detail" table :

The "Owner _Reserve" table :

P.19

The "Animal" table :

The "Animal _Detail" table :

The "Animal _Treat" table :

P.20

The "Appointments" table :

The "Appointments _Detail" table :

The "Appointments _Result" table :

P.21

The "Prescription Drugs" table :

The "Prescription Drugs _D" table :

The "Prescription Drugs _R" table :

P.22

This is are all table list in the Database Management System (DBMS) :

So has are eighteen tables and ninety record. P.23

Task 4

Set-up and test all of the following queries using Structured Query Language (SQL). Provide printouts of SQL code for each query and the output produced when you run the query in the database you have

developed (20 Marks)

Using Structured Query Language (SQL)

Request :

Display the names and addresses of the branches of Petcare and the names of all the veterinary doctors working at each of the branches. Any specialism(s) of the veterinary doctors should also be shown.

SQL Code :

SELECT [Branch Petcare_Detail].[Branch Name], [Branch Petcare_Detail].Address, [Veterinary Doctor_CM].[Doctor Name], [Veterinary Doctor_Detail].[Branch With], [Veterinary Doctor_Detail].[Specialise Animal]

FROM (((([Prescription Drugs] INNER JOIN (((Owner INNER JOIN (((Animal INNER JOIN Animal_Detail ON Animal.[Animal ID] = Animal_Detail.[Animal ID]) INNER JOIN Animal_Treat ON Animal_Detail.[Animal Name] = Animal_Treat.[Animal Name]) INNER JOIN (((((Appointments INNER JOIN Appointments_Detail ON Appointments.[Appointments ID] = Appointments_Detail.[Appointments ID]) INNER JOIN Appointments_Result ON Appointments_Detail.[Doctor With] = Appointments_Result.[Doctor With]) INNER JOIN [Branch Petcare] ON Appointments.[Appointments ID] = [Branch Petcare].[Appointments ID]) INNER JOIN [Branch Petcare_Detail] ON [Branch Petcare].[Petcare ID] = [Branch Petcare_Detail].[Petcare ID]) INNER JOIN [Branch Petcare_Doctor] ON [Branch Petcare_Detail].[Branch Name] = [Branch Petcare_Doctor].[Branch Name]) ON Animal.[Animal ID] = [Branch Petcare].[Animal ID]) ON Owner.[Owner ID] = [Branch Petcare].[Owner ID]) INNER JOIN Owner_Detail ON Owner.[Owner ID] = Owner_Detail.[Owner ID]) INNER JOIN Owner_Reserve ON Owner_Detail.[Owner Name] = Owner_Reserve.[Owner Name]) ON [Prescription Drugs].[Prescription ID] = [Branch Petcare].[Prescription ID]) INNER JOIN [Prescription Drugs_D] ON [Prescription Drugs].[Prescription ID] = [Prescription Drugs_D].[Prescription ID]) INNER JOIN [Prescription Drugs_R] ON [Prescription Drugs_D].[Drug Name] = [Prescription Drugs_R].[Drug Name]) INNER JOIN [Veterinary Doctor] ON [Branch Petcare].[Doctor ID] = [Veterinary Doctor].[Doctor ID]) INNER JOIN ([Veterinary Doctor_CM] INNER JOIN [Veterinary Doctor_Detail] ON [Veterinary Doctor_CM].[Doctor Name] = [Veterinary Doctor_Detail].[Doctor Name]) ON [Veterinary Doctor].[Doctor ID] = [Veterinary Doctor_Detail].[Doctor ID];

The Result :

P.24

Request :

Display all the appointments for the whole of the Petcare organisation. This should be ordered by date. The result should display the branch the appointment is at, the name of the veterinary doctor the

appointment is with, the date and time of the appointment, the name of the animal the appointment is

for, the type of animal and the breed of the animal.

SQL Code :

SELECT Appointments_Detail.Day, Appointments_Detail.Times, [Branch Petcare_Detail].[Branch Name], [Veterinary Doctor_Detail].[Doctor Name], Owner_Reserve.[Owner Name], Animal_Detail.[Animal Name], Animal_Treat.Classification

FROM (((([Prescription Drugs] INNER JOIN (((Owner INNER JOIN (((Animal INNER JOIN Animal_Detail ON Animal.[Animal ID] = Animal_Detail.[Animal ID]) INNER JOIN Animal_Treat ON Animal_Detail.[Animal Name] = Animal_Treat.[Animal Name]) INNER JOIN (((((Appointments INNER JOIN Appointments_Detail ON Appointments.[Appointments ID] = Appointments_Detail.[Appointments ID]) INNER JOIN Appointments_Result ON Appointments_Detail.[Doctor With] = Appointments_Result.[Doctor With]) INNER JOIN [Branch Petcare] ON Appointments.[Appointments ID] = [Branch Petcare].[Appointments ID]) INNER JOIN [Branch Petcare_Detail] ON [Branch Petcare].[Petcare ID] = [Branch Petcare_Detail].[Petcare ID]) INNER JOIN [Branch Petcare_Doctor] ON [Branch Petcare_Detail].[Branch Name] = [Branch Petcare_Doctor].[Branch Name]) ON Animal.[Animal ID] = [Branch Petcare].[Animal ID]) ON Owner.[Owner ID] = [Branch Petcare].[Owner ID]) INNER JOIN Owner_Detail ON Owner.[Owner ID] = Owner_Detail.[Owner ID]) INNER JOIN Owner_Reserve ON Owner_Detail.[Owner Name] = Owner_Reserve.[Owner Name]) ON [Prescription Drugs].[Prescription ID] = [Branch Petcare].[Prescription ID]) INNER JOIN [Prescription Drugs_D] ON [Prescription Drugs].[Prescription ID] = [Prescription Drugs_D].[Prescription ID]) INNER JOIN [Prescription Drugs_R] ON [Prescription Drugs_D].[Drug Name] = [Prescription Drugs_R].[Drug Name]) INNER JOIN [Veterinary Doctor] ON [Branch Petcare].[Doctor ID] = [Veterinary Doctor].[Doctor ID]) INNER JOIN ([Veterinary Doctor_CM] INNER JOIN [Veterinary Doctor_Detail] ON [Veterinary Doctor_CM].[Doctor Name] = [Veterinary Doctor_Detail].[Doctor Name]) ON [Veterinary Doctor].[Doctor ID] = [Veterinary Doctor_Detail].[Doctor ID]

ORDER BY Appointments_Detail.Day;

The Result :

This two part SQL code is to base the table, it output out in the database. So in the database, the tables is equal the SQL code and the SQL code is equal the tables. So the table in database, actual is running the SQL code.

P.25

Output SQL Code Methods :

In the "Create".

Use the "Query Design".

Add the table in "show table".

To choose are need information

"Run" to testing. P.26

To test the table have or not have the error.

If no have are error, go to "SQL View"

Last, this times have are SQL code.

P.27

Task 5

Explain any assumptions you have made when analysing, designing and implementing the above

database, justify the approach you have taken and explain any alternative approaches you could have

taken to any of the above tasks. Discuss any changes you would make to improve your work.

(10 Marks)

Always the system must have are database. It is because the system will have some information,

and the information have some classification, sometimes the system not have database, they will not faultless system. So we must design the database for system. So we need are database administrator to design and control the database. So the database administrator is very important in the database and it has are big responsibility in the database for system.

After, the database will always need Database Management System (DBMS) to manage and design. The Database Management System (DBMS) important function is creates the database for system, but it has are Data Definition Language (DDL), so the SQL code is the Data Definition Language (DDL). So the SQL code is so much important in the Database Management System (DBMS).

The database administrator work always have are data analysis, data control, data security, data privacy, data share and data integrity in the Database Management System (DBMS) for the system. So the database administrator will make and process one of the so match databases for the system. One of the databases must match are one of the system, can't use and work in other system. It is because every system must have are every condition and feature, so every database must to base on every system to custom make and keep the database have connection.

The database administrator in the Database Management System (DBMS) must work always have

are create table, update table, edit table and delete table from the system. And the database administrator shout protect are database all record, so always have are buck up the database all record and recovery. So the database administrator the work is so important and have are big

responsibility.

P.28

Why to design this Petcare Database for done to result. It is because every one branch must have are database to save are some data about for Petcare information. Every branch database must have are doctor information, branch petcare information, animal information, owner information, appointments information and the prescription information, so in the database must set the their "ID" and their detail information in fine classification. Set the "ID", it is because in the database have are search function, so if not set their "ID" the information will very random and did not search are correct record. So the set the "ID" produce is very important in the database.

In the database must need to regular. So database classification will need to separate clear. In the

Petcare Database to separate are six classification, is "Branch Petcare", "Veterinary Doctor", "Appointments", "Owner", "Animal" and "Prescription Drugs". Their six classification must have are

exclusive detail information. So the data can keep are separate clear, the database data separate

is so much important in the database design point. If the database data classification not separate,

the database will sometime have are data lose.

In the database are primary key and foreign key design is so much important. It is because in the database to process data search and input some data procedure is main about the primary key and foreign key, sometime always to use about their. So in the Petcare Database the primary key, it has

"Doctor ID", "Petcare ID", "Owner ID", "Animal ID", "Prescription ID" and "Appointments ID" in the database. So the database primary key is to base database information classification to set that.

After, in database the foreign key is too much important with primary key. But foreign key is under to primary key one level. The primary key and foreign key must have are relationship connection in the

database for system.

In the database "Branch Petcare" entity have all about the Petcare information. Every veterinary doctor is work in every branch petcare. Every veterinary doctor will has appointments. Every appointments will has are record detail. Every animal and owner detail information is record in every

branch petcare. Every drugs is has are detail and record with who doctor to use for animal. So in the

database every classification must has are relationship.

P.29

In the Database Management System (DBMS) design have are time will have are bad design.

This is are dad design in the database. It is because the "Address" is set to primary key. The problem is in the "Address" information always is very long work. So in the search function, input

the key work is so much, is so very convenient. This the bad design in the database search function result will sometimes have are data error and wrong.

So this is are correct database design. It must use the "Owner Name" to set are primary key.

In the database, the search key work is short, so it to very easy to search. This the that design in the database search function result will sometimes have are data correct.

In the database, the primary set to what classification is very important. It will affect the database

search function result.

P.30

The Database Management System (DBMS) always the security problem.

In the Options

Use the "Enable this contect

"OK"

P.31

Conclusion :

Finish the Petcare Database. I feel that to……

The database administrator is so important in the database. It is because they work is development and design database, so the database structure integrity is the database administrator responsibility.

After, the good database design for the system is so important. It is because all the about system information and data is save in the database, so if the database design structure integrity have are

Problem, the system process produce will have are error and wrong. So the database design is

and development is so responsibility important work to database administrator.

The database administrator is so important in the database, but the database can have are data administrator. They work is manage the data for database. The data for database is so important.

It is because the database must have are data, so the data to database is main element. If the

data have are lose and wrong or incorrect, it effect will so big. It will effect to database data reliability,

and then will effect system result.

The Database Management System (DBMS) will must not use to big organization system or big system. It is because the Database Management System (DBMS) function is so less, it only can to

manage the small classification system and small organization system. So if use to big classification system and big organization system, I feel can to use the SQL server. It is because the SQL server

function is so more and the SQL server technology can support so more. So the SQL server is so match to use in the big classification system and big organization system.

In the last, the database for system, the primary key and the foreign key set up and design too much

important. It is because in the database or system, the search function and the input data produce is

have are relationship to primary key and the foreign key, so the primary key and the foreign key must

set and design careful.

P.32

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.