Swagger Distributionâ€™s partners/customers include a variety of clothing companies. Swagger Distribution utilizes a database to store information on
the partner companies and the orders that are received. You will review the provided
for Swagger Distribution and summarize what the tables contain
and what the queries do. Be sure to apply key terms that you have learned such as â€œmetadata.â€ Based on information provided, you will change one data type in
one of the tables. Specifically:
Open up each table in the database to look at the data and examine its formatting. Be sure to open each table in regular view and design view. Describe
each table and the information it stores. Discuss any data types present other than text.
Open up the table â€œClothing Productsâ€ in design view. Change the data type of the â€œRetail Priceâ€ field from â€œtextâ€ to â€œCurrency.â€Â Now reopen the table
â€œClothing Productsâ€ in design view and notice the change.Â Provide a description of your actions and the results.
Run the query â€œRetail Purchasesâ€ by double-clicking on the query. Make note that it is an empty query. Open up the query in design view. Make note of
the actions it is taking and how the tables are linked. Why does the query provide no results? Describe how the tables are linked together and what the
query is doing.
Open up the table â€œRetail Stores.â€ Make selections for each retailer in the â€œClothing Itemâ€ field. Now close the table. Re-run the query â€œRetail
Purchases.â€Â Do you now have results? What do these results represent? Describe each column in the table. The screenshot of your results needs to be
included with your final submission for this milestone
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.