identify and list all entities described in each user requirement.

| October 14, 2019

a.    Analyse the all user requirements, identify and list all entities described in each user requirement.
b.    Add attributes to these entities and represent these entities (or Tables) and attributes as a collection of Tables and attributes. You are required to arrange them as given in the example below.
NB: Select a suitable primary key for each table and underline it.
Eg.     Student (StudentID, Fname,…….
c.    Outline all relationships between entities.
Eg. :  One students can apply for many open positions (Job postings) in all companies  – One-to-many,
d.    Determine the functional dependences.
Eg.  StudentID  Fname, address,  ……
e.    Then normalise these tables. Make the normalization to 3NF. Show every step in the process.
2.    Represent the structure of your database visually by using the entity-relationship (E-R) diagram.  If you make any assumptions about data that doesn’t appear in the problem, these must be clearly described.
You need to use Visio or any other software tool to create the ER diagram.
3.    Build this model using MS Access/ MS SQL Server by creating these tables and Relationships.   Populate these tables with appropriate data, include at least 3 records in each table.
4.    Give one example of a type report that can be obtained from this “MIT training” database.

Order your essay today and save 30% with the discount code: ESSAYHELPOrder Now