A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules:
Create and Populate the Database
Create the tables and relationships in Access
Integrate the data from the spreadsheets
Create query 1 – Create an Action query 1 – Action queries can delete records, update data, append data from one or more tables to another table, and make a new table. See your professor
Create query 2. – Multiple criterion query
Create query 3. – Crosstab query
Discuss database benefits when businesses use queries, forms, and reports
Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues
Edit, spellcheck, and list references
In 500 words or more, discuss the risk and costs of compromised data integrity breaches. Focus on integrity (nonalteration) not confidentiality (nondisclosure). Look at military, education, science, medicine, finance, utilities, municipalities, etc.
Use at least three sources. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list. Cite your sources. Do not copy. Write in essay format not in bulleted, numbered or other list format.
It is important that you use your own words, that you cite your sources, that you comply with the instructions regarding length of your post. Do not use spinbot or other word replacement software.
I need it to completed by 12 pm est