Design the Database - E R Diagram - Engineering Assignment Help

Assignment Task :

1. Select a real-world application for which a database system would be needed.

2. Model the domain of the application and define its functionality

3. Design the database

4. Implement it using a RDMS (MySQL or Microsoft SQL Server) ? Populate the database, write statements to manipulate the database, write queries to retrieve information, explore other aspects such as constraints and triggers.

In selecting the application domain for your project, we suggest that you choose an application that you enjoy working with and are interested in - e.g. a hobby, a student organization you're involved in, a business that interests you. It's especially nice if you pick an application where you can populate your database using real, as opposed to fabricated, data.

Phase 1

1. Abstract: a short (approximately one paragraph) description of the database application you propose to work with throughout the course. Your description should be clear and concise. It should also include any constraints that need to be imposed based on the application being modeled.

2. Mission statement.

3. Mission objectives.

4. A list of uses cases that include actor and step-by-step descriptions.

5. An E/R diagram for your proposed database. Underline key attributes for entity sets, specify relationships with arrowheads.

Your E/R diagram must have at least 5 entities, in order to guarantee the sufficient database operations. When defining entities, you should avoid two common mistakes: splitting one entity into multiples ones, or mixing multiple entities into one.

A draft report of the above will help you to identify the development objectives and implementation details. The draft can be refined and augmented in the next stage. 

Phase 2

At the second phase, you will finish the following tasks:

1. Complete E/R diagram from Phase 1: on you E/R diagram, clearly describe each entity (including, list of entity attributes, the entity primary key, and any foreign keys) and each relationship with its multiplicities. You can modify and improve the previous E/R diagram if necessary.

This Engineering Assignment has been solved by our Engineering  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.