Data Modeling and Design Help
SkrubbzI'm just plain stuck. I hate databases!!!! Please help!!!! Thank you!!
Professional Litigation User Services (PLUS) is a company that creates all types of visual aids for judicial proceedings. Clients are usually private law firms, although the district attorney's office has occasionally contracted its services. PLUS creates graphs, maps, timetables, and charts, both for computerized presentations and in large sizes for presentations to juries. PLUS also creates videos, animations, presentation packages, slide shows, and anything else of a visual nature that can be used in a judicial proceeding to make, clarify, or support a point.
Raj Jawahir is responsible for tracking the daily payments received from PLUS clients. You will help him maintain the Payments database by completing the following:
Figure 1
Field Name | Data Type | Description | Field Size | Other Properties |
Payment# | text | primary | 5 | |
Firm# | text | foreign | 4 | |
DatePaid | date/time | format: mmm dd yyyy (custom format) | ||
AmtPaid | currency | format: standard |
Figure 2
Payment# | Firm# | DatePaid | AmtPaid |
10031 | 1111 | 06/03/2001 | 2500.00 |
10002 | 1147 | 06/01/2001 | 1700.00 |
10015 | 1151 | 06/02/2001 | 2000.00 |
- Start Microsoft Access and open the Payments database located in the 'Payments' zip file.
- Create a table named Payment using the table design shown in Figure 1 above (Hint: Make sure that you include spaces between components of the custom format for the Date Paid field "mmm dd yyyy").
- Add the payment records shown in Figure 2 to the Payment table.
- Modify the structure of the Payment table by completing the following:
- Field Name: Deposit#
- Data Type: Text
- Field Size: 3
- Move the DatePaid field so that it follows the AmtPaid field.
- Use the Payment data sheet to update the database as follows. Enter the following Deposit# values for the 3 records:
- 101 for Payment# 10002
- 102 for Payment# 10015
- 103 for Payment# 10031
- Add a record to the Payment data sheet with the following field values:
- Payment#: 10105
- Deposit#: 117
- Firm#: 1103
- AmtPaid: 1750.00
- DatePaid: 06/20/2001
- Use the Payment data sheet to update the database as follows. Enter the following Deposit# values for the 3 records:
- Raj created a database named PlusPays that contains recent payments in the Payment Records table. The Payment table you created has the same format as the Payment Records table. Copy all the records from the Payment Records table in the PlusPays database (located in the Payments.zip folder) to the end of your Payment table.
- Use the Access Help system to learn how to resize data sheet columns to fit the data, and then resize all columns in the data sheet for the Payment table.
- For Payment# 10002, change the AmtPaid value to 1300.00.
- Delete the record for Payment# 10096.
- Take a screenshot of the first page of data from the Payment table data sheet, and then save and close the table.
- Save the .accdb file when you are finished.
Assignment Guidelines:
- Complete all of the steps outlined above in the assignment description.
- When you are finished, take a screenshot of the first page of data from the finished data sheet. Save a copy of the database file, and name it U2A1LastName.accdb.
- In a Word document, answer the following questions:
- What potential problem do you see with the Deposit# field?
- What business assumptions were made when defining this table?
- Place your screenshot in your Word document, and zip both the .accdb file and the Word document into a single .zip file.
Your submitted assignment (125 points) must include the following contained within a .zip file:
- You Word document that contains your answers to the questions in the assignment guidelines and the screenshot of your data sheet.
- Your saved copy of the .accdb file.
- 11 years ago
- 10
Purchase the answer to view it
- payments.rar
- Factoring expressions
- a buildings shadow is 48 feet long using indirect measurement find the hieght of the buildin g
- The stored energy an object has as a result of its height above the ground
- Analysis
- i want to do a research in information security include 3 source i wanna have it before 11;30 can u...
- Two goods are substitutes when a decrease in the price of one good
- Write an equation for the line with a slope of 3 passing through (2,5) in point-slope form, and slope-intercept form.
- How does a volcanic eruption like Mt. Pinatubo (PEE-nah-TOO-boh), affect climate?
- Help with Essay!!
- a vertical rod 8ft high casts a shadow 6ft long.at the same time, a nearby tree casts a shadow 15ft...