DBM/261 help

SoccerBoss
Category:
Other
Price: $50 USD

Question description

week 2 assignment 

individual<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

database creation           create a microsoft access database using riordan manufacturing’s 2005 sales figures. 

normalize the tables to the third normal form. 

create relationships among tables using the relationship tool. these relationships must include settings for referential integrity and cardinality. 

create an extended erd of your newly created database, using

microsoft word, powerpoint, or visio. 

include primary keys, foreign keys, fields, relationships, and cardinality in the erd.

-----------------------------------------------------------

week 3 assignment

individual

query-building exercise                build queries through sql along with the query-building tool with sales databases built in week two for riordan manufacturing.

create a separate table for query information. include the query name and query description. 

enter data into the fields, naming and describing as many queries as you can, and then write two thirds of the queries using the query-building tool.

write the remaining queries in sql.

create a new query without the tools and enter the sql into its view.

test your queries to verify that they return the data you described.

----------------------------------------------------------

week 4

individual

database reporting        this assignment uses the database from the week two assignment as you develop a set of reports using the report design tool. 

write a sales detail report using the report design tool that shows sales information, including customer, product description, retail price, and cost. 

execute the subtotal retail price by customer, quarter, and product. 

write a profit margin report using the report design tool that shows a graph of profit margins by product and by quarter. 

incorporate the profit margin report into the sales detail report as a subreport.


Tutor Answer

(Top Tutor) Daniel C.
(997)
School: University of Maryland
PREMIUM TUTOR
Studypool has helped 1,244,100 students
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors