Task 9 (Course PROJECT)
Research Web or
based on your knowledge and experience, select a typical Urgent Care
type health care service provider. Any Health Care Services at Urgent
Care level will be fine.
Create a 3-4 pages of document in WORD Format about your selected Health First Care Service Provider to include the following:
What kind of Databases they use?
Describe some of the Tables included in their Database (DB),
and explain briefly role and function of each table, what is it use for?
What other object (like Query, Form…) besides the tables are
included within your DB? Describe each
briefly.
Is the DB managed on site or remotely from Central Office
(or other locations)?
If you act as their Database Administrator (DBA) what will
be your solution, workaround, fix for the following scenarios:
·
DB Auditing Shows a lot of Redundant Data. Propose your fix and solution. How will you fix it?
·
Users have started complaining the DB performance
is NOT good, and it is slow. Propose
your fix and solution. How will you fix
it based on what you have learned from this course?
·
The Organizations has been grown and currently
DB size has grown exponentially. It has
become too large. As a DBA, what
concerns will you have. Describe briefly
list of your concerns and explain each concern and your corresponding solution to
fix that.
·
Describe your DB Disaster Recovery strategy and
steps to keep DB always up and running.
What will you do to have your DB available 7*24?
·
As DBA, how will you train your other DB Staff
working with you?
·
Describe Steps you will use to improve your DB
Security
At the end of your document, define each of the following in
one sentence. Please be to point:
1.
Database
2.
Data
3.
Information
4.
Tables
5.
Record
6.
Field
7.
Primary
Key
8.
Query
9.
Form
10. Report
11. Trigger
12. Relationship
Submit your 3-4 pages of WORD document in Moodle
0 comments