DBM/261 help

timer Asked: Feb 7th, 2013

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


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


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) Studypool Tutor
School: UT Austin
Studypool has helped 1,244,100 students
flag Report DMCA
Similar Questions
Hot Questions
Related Tags

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