Provide a brief synopsis analyzing the detailed requirements

Assignment Help Database Management System

Reference no: EM131872246

The Database Design Proposed are the following:

1715_ER diagram.png

1. Design a working prototype using SQLite Database. The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS).

2. Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design.

3. Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.

USER ROLE:

Program coordinator= database administrator/authorize who able to access and use the database. Responsible for review result from periodic audition and the final report before submission.

Lifestyle Coach====are user able to access and upload new data (cannot delete/update). Responsible for periodic database audit.

Database development team (3 nurse) =====responsible for update, backup, and maintenance as well as retrieve the final report for submission.

I. Thoughtfully analyzes and evaluates the detail requirements. Draws warranted, judicious, nonfallacious conclusions. Information and evidence are accurate, appropriate.

II. Demonstrates a full and deep knowledge of the subject. Develops all of the database prototype assignment components. Accurately presents the impact of the database in practice.

III. Content is comprehensive, accurate, and persuasive; rationales are clearly stated. Research is adequate, timely, and relevant, and addresses all of the issues stated in the assignment criteria.

APA references and format is required

Reference no: EM131872246

Questions Cloud

Calculate the modified internal rate of return : Assuming that the relevant cost of capital for Machines "A" is 13.50% and the relevant cost of capital for Machine "B" is 8.75%, calculate the modified internal

Describe the cyclic activated-sludge system : Describe the Cyclic Activated-Sludge System, discuss its mode of operation and the potential benefits as an equipment option for an activated sludge unit.

Net present value of hansen after-tax cost of the asset : Calculate the net present value of Hansen's after-tax cost of the asset.

What is the? bond yield to? maturity : The market price is ?$900 for a 16?-year bond ?($1,000 par? value) that pays 12 percent annual? interest, but makes interest payments on a semiannual basis

Provide a brief synopsis analyzing the detailed requirements : Provide a brief synopsis analyzing the detailed requirements of your prototype database design - Design a database prototype that includes diagrams

Net present value related to greshak proposed : Assuming that the relevant cost of capital for Machines "A" is 13.50% and the relevant cost of capital for Machine "B" is 8.75%, calculate the net present value

Rate for foreseeable future : At the end of the 5 years (i.e. at the end of Year 4), earnings growth rate is expected to fall to 4.75 percent and continue at that rate for foreseeable future

Investing in higher risk investments : He believes he can earn an average annual return of 9.0% by investing in higher risk investments over the next twenty years, but will put it in a lower risk

Why do ethics vary from person to person : You will need to establish a FAQ document and provide the following questions with their applicable answers.

User Account

All Pages