Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For this assignment, each Group is to build upon the Excel assignment. The objective of this assignment is to create a relational database to keep

image text in transcribed
For this assignment, each Group is to build upon the Excel assignment. The objective of this assignment is to create a relational database to keep track of company information and monthly stock prices. For this assignment each Group will need to import company profile and historical information for the five stocks selected in the Excel project into an Access database. One form, three queries and three reports will have to be created. The completion of this assignment requires that you use Access. In order to learn and practice Access you can use the materials from your CPS 1032 class or one of toe many tutorials on (specific usage through the Kean library is described here) or other places on too web. Create an Access database with the file name bang your Group, such as GroupA accdb. Create a company table to store toe company information by importing the table on the worksheet from (Step3) of toe Excel Assignment Do not forget to designate the appropriate primary key. Your table should look like the one below. Create a data entry form for this table and use it to add the information for 3 more IS/IT companies. Creels a Monthly Stock Price table to store the company information by importing the table on toe Monthly Stock Price from (Step 4) of the Excel assignment Do not forget to designate the appropriate primary key, What should the primary key be? Which fed (or combination of fields) are unique for each record? Using Yahoo! Financials find the monthly stock press for the three new companies that you added, for the same months you used in the Excel assignment. Add the new data to toe table. You' table should took like toe one shown below. As you create these tables in Access, set toe approvals field types (numeric. data, currency. etc.) and sizes. Field sizes that are unnecessary long for the data that will be stored in them reflect poor design. Assume that each of your tables may grow to several hundred records, and you should avoid wasting a lot of storage space. Create a relationship between the two tables. be sure to referential integrity Run the following 3 save each one with appropriate and companies that are not Display the ticker, name and number of employees of the companies with more than 50,000 employees

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

Students also viewed these Databases questions

Question

3. What may be the goal of the team?

Answered: 1 week ago

Question

Is how things are said consistent with what is said?

Answered: 1 week ago