Sign In
Not register? Register Now!
Essay Available:
Pages:
3 pages/β‰ˆ825 words
Sources:
3 Sources
Style:
APA
Subject:
Health, Medicine, Nursing
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 12.96
Topic:

Database Design Project: Proposal

Essay Instructions:

In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize 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). Refer to "Supplement: SQL Examples for SQLite Database," for the link to the SQLite Database download and examples.
The working prototype should include the following:
Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design and how it would be used to support data warehousing, reporting and mining
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.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center.
You are not required to submit this assignment to LopesWrite.

Essay Sample Content Preview:

Database Design Project
Author Name
Institution Affiliation
Synopsis
SQLite comprises of a product library that helps actualize zero-management, value-based, independent SQL database motor. The source code is always required to accomplish a particular task (Tillmann, 2017). The database design protocols focus on the creation and maintenance of a database for an organization, such as a bank or a hospital, which can be easily accessed by users of its different departments including bankers, customers, doctors, nurses, and other healthcare experts. With this, it becomes easy for them to access customer details whenever there is an urgent situation (Davidson, 2004). By automating the record system, users can easily identify or locate relevant data, and it should be kept in mind that the database always contains information collected from diverse sources. Users can get access to this information based on their queries. The database tends to focus on patient data along with the information of healthcare experts.
Bank Manager Table
Field*Relationship*Manager ID*Primary key*Secondary key*Name*Age*Gender*Weight*Phone number*Address*Insurance coverage*Nature of job*Manager number
Cashier Table
Fields*Relationships*Cashier ID*Primary keyroom*Secondary keyword*Date of joining*Relationships
Customer Table
Fields*Relationship*Doctor/Customer name*Primary key*Secondary key*Doctor name*Department name
Receptionist Table
Fields*Relationship*Receptionist name *Primary key*Name of the receptionist
I have made a model of an online table. In the graph given ...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Essay Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now