Design a working prototype using sqlite database

Assignment Help Database Management System

Reference no: EM131872234

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: EM131872234

Questions Cloud

Find a publicly traded company that trades on the NYSE : Find a publicly traded company that trades on the New York Stock Exchange (NYSE) or on the NASDAQ to analyze.

Write a short investigations about environment policy : You will have five investigations. These will enable you to delve more deeply into topics. Write a Short investigations about environment policy.

Assess the company human resources competitive position : Leveraging the work completed in the Individual Assignments for Units 2 and 3, assess the company's human resources competitive position.

Investment bank has the financing outstanding : The Saunders Investment Bank has the following financing outstanding. Debt: 30,000 bonds with a coupon rate of 6 percent and a current price quote of 112;

Design a working prototype using sqlite database : Design a working prototype using SQLite Database. The SQLite database is a small, lightweight database application, suited for learning SQL and database concept

What was the purpose and type of meeting held : Provide details on the arrangements made for the meeting. If these arrangements were sufficient or not?

What is the bond current yield : The bond pays coupons semiannually. What is the bond's current yield?

Result in initial aftertax cash savings : Och, Inc., is considering a project that will result in initial aftertax cash savings of $1.9 million at the end of the first year,

What was the gross profit : Sprint Shoes Inc. had a beginning inventory of 9,100 units on January 1, 20X1. The costs associated with the inventory were:

User Account

All Pages