Think of a Web-Based Software Application - Computer Science Assignment Help

Assignment Task

1. Think of a web-based software application (with a central database), that you think will be useful to many people

2. Write a brief description of the application
– Who will be the users?
– What are the benefits of this application?
– List of functions & features of the application
– How many users will use it simultaneously?

3. Draw ER diagram for the application 
– Make sure that there are at least 7 entity types in the EER diagram
– Use the notations from the textbook or reference book only
– It is recommended to use pen and paper draw the EER diagram with hand

4. Convert ER model to relational model 
– Clearly define the steps you have used to achieved the relational database schema
– You may argue based on the 1:1, 1: N and M: N type of relationships with total and partial participations.
– Highlight the primary keys and foreign keys in the relational database schema

5. Normalize the Relational model to at least 3NF.
– Use few functional dependencies (at least 5 in total)
– Justify starting from 1NF to 2 NF and to 3NF
– Decompose in BCNF
– Check that your decomposition is Lossless Join and Dependency preserving.

6. Write SQL queries to fulfil the end user needs 
– Write at least 5 SQL queries make sure to use a your concepts from the lab sheets uploaded on e- learn portal
– You can copy and paste or share the screenshots of your execution and results.

7. Design indices to enhance the performance of queries and justify your choice of indices
– Indexes are used to speed the retrieval. You can use any index structure. Critically justify your index whether it is primary, secondary, or clustering index.
– Argue on the space utilized and time saved on the retrieval.
– You may take some random values to prove the same.
– Take a small sample of at least 6 values on any attribute of the any table and construct the B+ tree .

This Computer Science Assignment has been solved by our Computer Science 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.