Use Visio or other software tool to create ER diagram | Good Grade Guarantee!
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.
QUALITY: 100% ORIGINAL – NO PLAGIARISM.
- **REMEMBER TO PRECISE PAGE NUMBER**
- Hit The Order Button To Order A **Custom Paper**