support@essaywritingexpert.org
Below we have the list of requirements for the project in the CEN 202 – Database Management Systems course (CEN II).
Please note that each of the steps consists of a part of the total percentage of the project evaluation.
Project Outline and Planning ( 10%)
The first step involves providing a description of the project and an outline of the steps involved in organizing it. (5%)
A core idea, a brief description of it, followed by the steps you intend to take in the other two phases should be sufficient. (5%)
Research and Idea Consolidation (30%)
This phase includes looking into possible proposals for technologies and techniques to use for your project. The proposal has to revolve around a database about a Library System however, as you have already been informed.
– Req. 1: Present a core concept of improvement (speed, normalization etc.) (15%) – – Req. 2: Describe the specifics of your improvement (what makes your database faster/how is normalizing your database beneficial). (15%)
Project Execution (60%)
The materialization of your project will involve a number of files:
– Provide a complete ER Diagram of your solution, with all necessary rationales. (15%) –
Provide the associated RS schema, with notes on necessary conversions between the two
(ERD<->RS) and rationale for certain design choices (if it has not been covered by the one
in the ER diagram). (15%)
– Database dump, with the associated SQL files and queries. (30%)
– CREATE & INSERT DATA (10%)
– MANAGERIAL QUERIES RELATED TO YOUR PROJECT (20%)
– MIN 20 MANAGERIAL QUERIES