Reference no: EM13334773
Case Study
In this case study, you will design and build a small database application, using Microsoft Access.
Step 1 - In Word, identify a potential database application. It should be based on data you understand well, such as student data (refer to text), a hobby (see Lesson 8), or a set of data you use on the job. When you have made your choice, proceed to Step 2.
Step 2 - In Word, introduce your application and explain whether it is based on the example in the text, a hobby, or your job. Also explain how you came to understand the data, and provide detail on the uses for this database.
Step 3 - In Word, design two tables (more if you like) that might be part of the database, without normalization (i.e., they should contain fields that might make sense one table at a time, but that will cause problems with data redundancy and referential integrity. Your tables must each contain at least 5 fields (columns) and 5 records (rows).
Step 4 - In Word, explain why the tables above are not ideal for database applications (i.e., explain what problems with data redundancy and referential integrity they would cause). This has been explained in Lesson 8, but you are welcome to research the subject on the Web to add to your knowledge. Ensure sources are referenced correctly.
Step 5 - In Word, explain what tables you plan to build in Access. Normalization procedure explicitly documented. Identify what the primary key will be for each table. Identify what the foreign keys will be for each table. Explain what your query(s) are intended to show, and why it (they) would be useful. Conclude by summarizing the benefits that can be obtained by replacing the above tables with a well-designed database.
If you have made mistakes in this part, the next steps will be impossible.
Step 6 - In Access, build a database of at least 2 tables, showing good database design as discussed in Lesson 8. Use relationships to join the tables and then prepare a Query that will show meaningful results, using fields from both tables. Add a form that would be used for data entry. Provide meaningful sample data.
Step 7 - Submit BOTH your completed Access Database and your Word file via the Assignment Tool.
|
Is a communication of this nature ethical
: Attorney S, representing C, sent a printed or mimeographed collection letter to M, stating that he had been employed by C and that he had been instructed by C to file suit immediately in order to reduce M's debt to judgment. S stated that he was auth..
|
|
Does this action violate the canons of ethics
: Does this action violate the Canons of Ethics?
|
|
A violation of the code of ethics
: In this situation would it be a violation of the Code of Ethics (1) for Xto represent the defendant in a criminal murder case where he will receive a substantial fee to assist Attorney Z who has no connection with X or Y and lives in a neighboring..
|
|
The judge of a court of record to borrow money
: 1. Is it improper for an attorney who is also the judge of a court of record to borrow money from individual attorneys who practice in his court? The loans are sometimes evidenced by a promissory note but are otherwise unsecured.
|
|
Design and build a small database application
: In Word, identify a potential database application. It should be based on data you understand well, such as student data (refer to text), a hobby (see Lesson 8), or a set of data you use on the job. When you have made your choice, proceed to Step ..
|
|
What is the revenue and collection cycle
: What is the revenue and collection cycle and in addition to ACCOUNTS RECEIVABLE, what are two other significant accounts related to REVENUE and COLLECTION?
|
|
A violation of the code of ethics
: A violation of the Code of Ethics
|
|
Determine the final speed of each disk
: Two shuffleboard disks of equal mass, one orange and the other yellow, are involved in an elastic, glancing collision. Determine the final speed of each disk
|
|
Calculate the moment of inertia of this system
: A 135-kg platform oriented horizontally consists of a uniform disk of radius 1.59 m and can rotate about the vertical axis through its center. Find the moment of inertia of this system
|