ASSIGNMENT | ASSIGNMENT 0N REPORT.

RUNNING HEAD: ASSIGNMENT REPORT 1
Assignment Report
Your Name
School-Affiliated

ASSIGNMENT REPORT 2
Crow’s Foot System
This is an example of a data modelling method. Such an example is the Entity Relationship
Diagram. The Crow’s foot system makes use of the different entities, relationships and modality.
Entity refers to the place, person or thing which is used in the collection of the multiple data
instances (Zaria, 2013). The relationships helps in illustrating the entities association. Finally,
the modality otherwise called cardinality which are the indicators of the relationship through
rules. The cardinality maximizes on the entity instances that are associated with it through the
entity (Brady, 2017).
Database design and development part
There are ten tables that were involved in creation of the different tables to include applications
table, the customers table, the employee category table, the external employee table, the
managers table, the owner table, the property table, the rental table, the repair job table and the
staff table. The various tables have database content were used to serve as the examples needed
to run the queries and reports. The examples of two tables are;

ASSIGNMENT REPORT 3
The queries used in this database are five;
Each query was an answer to a question asked. The tables were being queried to give results
based on specified requirements set for every query. The examples of these queries are
represented below.

ASSIGNMENT REPORT 4
The last part represents the report. Only one report has been done. The report brings together the
queries and the table content to make a report that can be read and understood by the users of the
information. The only example of a report that featured in this database system.