Browse over 20 million
homework answers & study documents

pos410_week5project

Type

Homework

Rating

Showing Page:
1/7



 !"#$%&
$'#(
!#("
()*+,
%+#(
%$ !&,,-,.+*/0,"1"&
-,&10*,2+*,-,&+
$,&-$,&1

Sign up to view the full document!

lock_open Sign Up
3,2$*2&(
create database kff_coa
3,2$2&4&,2-2,,#*-
,,5-1
create table stores_tbl
(
store_id int identity primary key not null,
description nvarchar(50) not null
);
3,2$&#4&,2-2,,#*-
,,5-1
create table sections_tbl (
department_id int identity primary key not null,
description nvarchar(100) not null
);
3,2$&4&,--,-13,
&-.**+11
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)
);
3,2$&#4&,--2,,13,
673%"37893 !&#,*.#.13,-.*
*+11
create table transaction_tbl (
transaction_id int identity primary key not null,
date_time datetime not null default GETDATE(),
store_id int not null,
account_number nchar(6) not null,
value money not null default 0.00
);

Sign up to view the full document!

lock_open Sign Up

Sign up to view the full document!

lock_open Sign Up

Unformatted Attachment Preview

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 ...
Purchase document to see full attachment

Anonymous
Had to paraphrase some of the content but overall, really useful material.

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Anonymous
Just what I needed… fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4