ICS 129 Week 13 Assignment (10 points) This assignment is based on lecture Chapter 06 -...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
ICS 129 Week 13 Assignment (10 points) This assignment is based on lecture Chapter 06 - Physical-level Design (Creating forms) Using the database created from Assignment 20, perform the following on Lastname_12.accdb: (If you did not complete the previous assignment, please email the instructor for a usable file) 1. Save the database as Lastname_13.accdb 2. Make changes to your database based on the feedback, if any, from Week 12 Assignment. 3. At this point in the assignment, the tables should not contain any data. Common mistakes this assignment stem from adding data directly to the table. You will be adding data using the forms that are creating further down in this assignment. 4. Automate the foreign key values in the Enrollment table by deleting the current relationships, then re-creating them using the Lookup Wizard. O The purpose of this is to make data entry for foreign keys (Enrollment ParticipantNum and Enrollment ActivityNum) more user-friendly. The name will be shown in the drop-down, instead of the surrogate key number value. 5. After completing the Lookup Wizard, the foreign key columns will be setup to be a drop- down menu. The drop-down menus should be blank at this point because there is no data entry yet. 6. Using the Form Wizard, create one form for each table to allow data entry. O O The primary keys in the ACTIVITY and PARTICIPANT table are surrogate keys, those fields should not be added to their respective forms. 7. Make any necessary adjustments (move/resize field names or values, etc.) to the forms to make them neat and readable. You should be making some kind of adjustment because the labels for each input field are taken directly from the column names. Please review the lecture video for steps on how to make adjustments. 8. Using the forms created: O O Add exactly 5 rows of data in the PARTICIPANT table. Add exactly 5 rows of data in the ACTIVITY table. Use simple names for the class name that are a few concise words - this is not a description, keep it short and simple. For example, archery, swimming, etc. Add at least 15 rows of data in the ENROLLMENT table. O 9. Save the database. 10. Submit the Yourname_13.accdb file to the Digital Dropbox. Notes on data entry: You can make-up the data yourself, or you can use the information in the BITS, Colonial, or Sports databases if you cannot come up with your own names, addresses, etc. ICS 129 Week 13 Assignment (10 points) This assignment is based on lecture Chapter 06 - Physical-level Design (Creating forms) Using the database created from Assignment 20, perform the following on Lastname_12.accdb: (If you did not complete the previous assignment, please email the instructor for a usable file) 1. Save the database as Lastname_13.accdb 2. Make changes to your database based on the feedback, if any, from Week 12 Assignment. 3. At this point in the assignment, the tables should not contain any data. Common mistakes this assignment stem from adding data directly to the table. You will be adding data using the forms that are creating further down in this assignment. 4. Automate the foreign key values in the Enrollment table by deleting the current relationships, then re-creating them using the Lookup Wizard. O The purpose of this is to make data entry for foreign keys (Enrollment ParticipantNum and Enrollment ActivityNum) more user-friendly. The name will be shown in the drop-down, instead of the surrogate key number value. 5. After completing the Lookup Wizard, the foreign key columns will be setup to be a drop- down menu. The drop-down menus should be blank at this point because there is no data entry yet. 6. Using the Form Wizard, create one form for each table to allow data entry. O O The primary keys in the ACTIVITY and PARTICIPANT table are surrogate keys, those fields should not be added to their respective forms. 7. Make any necessary adjustments (move/resize field names or values, etc.) to the forms to make them neat and readable. You should be making some kind of adjustment because the labels for each input field are taken directly from the column names. Please review the lecture video for steps on how to make adjustments. 8. Using the forms created: O O Add exactly 5 rows of data in the PARTICIPANT table. Add exactly 5 rows of data in the ACTIVITY table. Use simple names for the class name that are a few concise words - this is not a description, keep it short and simple. For example, archery, swimming, etc. Add at least 15 rows of data in the ENROLLMENT table. O 9. Save the database. 10. Submit the Yourname_13.accdb file to the Digital Dropbox. Notes on data entry: You can make-up the data yourself, or you can use the information in the BITS, Colonial, or Sports databases if you cannot come up with your own names, addresses, etc. ICS 129 Week 13 Assignment (10 points) This assignment is based on lecture Chapter 06 - Physical-level Design (Creating forms) Using the database created from Assignment 20, perform the following on Lastname_12.accdb: (If you did not complete the previous assignment, please email the instructor for a usable file) 1. Save the database as Lastname_13.accdb 2. Make changes to your database based on the feedback, if any, from Week 12 Assignment. 3. At this point in the assignment, the tables should not contain any data. Common mistakes this assignment stem from adding data directly to the table. You will be adding data using the forms that are creating further down in this assignment. 4. Automate the foreign key values in the Enrollment table by deleting the current relationships, then re-creating them using the Lookup Wizard. O The purpose of this is to make data entry for foreign keys (Enrollment ParticipantNum and Enrollment ActivityNum) more user-friendly. The name will be shown in the drop-down, instead of the surrogate key number value. 5. After completing the Lookup Wizard, the foreign key columns will be setup to be a drop- down menu. The drop-down menus should be blank at this point because there is no data entry yet. 6. Using the Form Wizard, create one form for each table to allow data entry. O O The primary keys in the ACTIVITY and PARTICIPANT table are surrogate keys, those fields should not be added to their respective forms. 7. Make any necessary adjustments (move/resize field names or values, etc.) to the forms to make them neat and readable. You should be making some kind of adjustment because the labels for each input field are taken directly from the column names. Please review the lecture video for steps on how to make adjustments. 8. Using the forms created: O O Add exactly 5 rows of data in the PARTICIPANT table. Add exactly 5 rows of data in the ACTIVITY table. Use simple names for the class name that are a few concise words - this is not a description, keep it short and simple. For example, archery, swimming, etc. Add at least 15 rows of data in the ENROLLMENT table. O 9. Save the database. 10. Submit the Yourname_13.accdb file to the Digital Dropbox. Notes on data entry: You can make-up the data yourself, or you can use the information in the BITS, Colonial, or Sports databases if you cannot come up with your own names, addresses, etc.
Expert Answer:
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
14. Give an example which shows that for a
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
In Mark A. Cohen, The Costs and Benefits of Oil Spill Prevention and Enforcement, Journal of Environmental Economics and Management Vol. 13 (June 1986), an attempt was made to quantify the marginal...
-
Mr. Milquetoast is enthusiastic about the prospects for Face book. He wants to invest $100,000 in the stock, but hesitates because Face book has never paid a dividend. He needs to generate $5,000 per...
-
If Tanisha has $100 to invest at 4% per annum compounded monthly, how long will it be before she has $150? If the compounding is continuous, how long will it be?
-
Jeffrey Lowe and Mona Ray are partners in a business. Statement paper, page 12 of a general journal, and a portion of the partnership's completed work sheet for the year ended December 31 of the...
-
The second largest public utility in the nation is the sole provider of electricity in 32 counties of southern Florida. To meet the monthly demand for electricity in these counties, which is given by...
-
4) The frame supports the distributed loading of X (N/m). Determine the normal and shear stresses at point D that act perpendicular and parallel, respectively, to the grain.The grain at this point...
-
Monthly return data are presented below for each of three stocks and the S&P index (corrected for dividends) for a 12-month period. Calculate the following quantities: - Alpha for each stock - Beta...
-
The following are extracts of two articles from BBC News. Facebook raises share price range after strong demand. 15 May 2012 Facebook, founded 2004, has raised the price at which it hopes to sell its...
-
Discuss self-understanding in middle childhood by providing a detailed example of the development of self-concept and a detailed example of the development of self-esteem in this stage. Information...
-
A 5%, 10-year bond has a yield to maturity of 3.75% and modified duration of 6.2 years. If the market is expected to increase by 125 basis points, what do you estimate will be the percent change...
-
Pete Peters read the following partial advertisement: Price $20,900; down payment $1,000; $390.85 per month for 60 months. 1) What is the amount financed? 2) What is the total finance charge?
-
The movie "Coco," is a wonderful film that depicts the Mexican "Day of the Dead" holiday which celebrates those who have passed. If you are so inclined, please describe in detail this Mexican...
-
Penske and Nuveen are all-equity firms. Penske has 20,000 shares outstanding at a market price of $84.50 a share. Nuveen has 10,000 shares outstanding at a price of $41.70 a share. Penske is...
-
Name the Supreme Court case that first introduced this to our judicial system. Defend the courts decision that a "right to privacy" is implied by the First, Third, Fourth, Fifth, and Ninth...
-
Assume a simple Keynesian depression economy with a multiplier of 4 and an initial equilibrium income of $3,000. Saving and investment equal $400, and assume full employment income is $4,000. a. What...
-
What is the difference between a specialization hierarchy and a specialization lattice?
-
Why can total participation of an entity type in a relationship type also be referred to as existence dependency of that entity type in that relationship type?
-
In categorization, what is meant by the property of selective type inheritance?
-
Determine the assets to revenues ratio for the commercial construction company. What insight does this give you into the companys financial operations?
-
Determine the collection periodwith and without retentionand receivable turns for the commercial construction company. What insight does this give you into the companys financial operations?
-
Determine the working capital turns for the commercial construction company. What insight does this give you into the companys financial operations?
Study smarter with the SolutionInn App