Create and populate the database tables

Assignment Help Database Management System

Reference no: EM131677947 , Length: word count:500

Complete BOTH parts of this assignment.

Part A: Write a 500-1000 word paper using Word discussing two of the additional DBA responsibilities mentioned briefly at the end of Chapter 6 under the "Additional DBA Responsibilities" heading.

Use at least two sources outside your text for this paper. Do not use Wikipedia. Use APA format for the paper, and be sure to cite all your sources using APA format. Submit your Word document for grading.

Part B: In Microsoft Access, create and populate the following three database tables, including foreign keys, using SQL.

Save all queries in the database. Assume the ID for each table is the primary key. Assume all fields are required. Assume all fields that contain only numbers are numeric type. Save the database as Personnel.accdb.

Once the tables have been created, encrypt the database with a password. Be sure the password is strong.

It should be at least 16 characters in length, and contain at least one of each of the following: upper-case letters, lower-case letters, numbers, and special characters.

Submit the password in the comments section of the assignment submission area.

Employees figure 1 Managers figure 2 Departments figure 3 You will have two files submitted for this assignment: the Word document for your paper in Part A, and the Microsoft Access database file (Personnel.accdb) from Part B.

Reference no: EM131677947

Questions Cloud

Discuss the internal-external and environmental risks : Briefly discuss the internal, external, and environmental risks, which might be likely to affect the business and result in loss of the facility, loss of life,

Critique how well the organization adapts to change : Identify economic, legal, and regulatory forces and trends.Analyze and explain the supply chain of the new division of the existing business.

Calculate the price of an individual tomato : Write a set of sentences that allows one to calculate the price of an individual tomato (or other object), given the price per pound.

Certain municipality experiences drastic water shortages : A certain municipality experiences drastic water shortages due to draught and water purification plant decay.

Create and populate the database tables : Create and populate the three database tables - briefly at the end of Chapter 6 under the Additional DBA Responsibilities heading

Comparisons of abstract measures in different units : An alternative scheme for representing measures involves applying the units function to an abstract length object.

Evaluate how the external environment : Using a firm as an example to evaluate how the external environment

How do you want your employees to react : How do you want your employees to react? Is there a particular way that will minimize legal liability?

Discuss the movement toward evidence-based assessment : What is your opinion of the movement toward evidence-based assessment. What are its advantages and drawbacks

Reviews

len1677947

10/13/2017 1:07:08 AM

Submit the Personnel.accdb file. Submit the password in the comments section of the assignment submission area. Employees figure 1 Managers figure 2 Departments figure 3 You will have two files submitted for this assignment: the Word document for your paper in Part A, and the Microsoft Access database file (Personnel.accdb) from Part B.

Write a Review

Required(*) Message

User Account

All Pages