pos410_week5project

Feb 3rd, 2012
Studypool Tutor
University of Phoenix
Course: axia college
Price: $10 USD

Tutor description

pos410_week5project POS 410 Week 5 Final Project Kudler Fine Foods Service Request SR-kf-009 SQL Accounting Database Organization: Kudler Fine Foods Locations: All Requester: Harvey Stephens Description of Request: Design an SQL database that contains the fields found in the company's Chart of Accounts. Add a balance field to the database. Create a query that will display all of the fields of the database and run a report totaling the balance field using test data added to the database.

Word Count: 1030
Showing Page: 1/7
POS 410 Week 5 Final ProjectKudler Fine FoodsService Request SR-kf-009SQL Accounting DatabaseOrganization:Kudler Fine FoodsLocations:AllRequester:Harvey StephensDescription of Request:Design an SQL database that contains the fields found in the company's Chart of Accounts. Add a balance field to the database. Create a query that will display all of the fields of the database and run a report totaling the balance field using test data added to the database.The following query creates a new database:create database kff_coaThe following creates a new table called store_tbl that uses two fields one of which is an indentity field and the other a text field. create table stores_tbl(store_id int identity primary key not null,description nvarchar(50) not null); The following creates a table called sections_tbl that uses two fields one of which is an indentity field and the other a text field. create table sections_tbl (department_id int identity primary key not null, description nvarchar(100) not null);The following creates a table called coa_tbl that uses seven fields five of the fields are required. The balance field uses a money datatype and a default value of 0.00.create table coa_tbl (store_id int not null,account_number nchar(6) not null,description nvarchar(255) not null,short_description nvarchar(255),balance money not null default 0.00,department_id int not null,primary key (store_id, account_number));The followin

Review from student

Studypool Student
" excellent work as always thanks for the help "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 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