Individual Paper

136 views 8:34 am 0 Comments April 27, 2023

DBM 380 Week 2 Individual Paper

For this assignment the author has chosen to create a database for accounting and revenue balancing to get

Berry’s Pest Blasters. This was chosen because there is small information available on the company intranet,

there are key facts that are arranged into PDF files but not into a manageable database in which this small

company could use in it’s accounting department. The environment for this is a series of entities for: Profit

Statement, “balance sheet”, and Cashflow Statement. Studying the existing PDF’s, many of the main at-

tributes what are the but not editable or readable for speedy information. Creating these sources would al-

low the accounting person(s) to keep up with all their various marriage models in financing not having rais-

ing costs of creating a greater database. This may be a single end user database made via Get, with that be-

ing extensible for a homegroup if necessary.

The difficulties and limitations of this sort of database operate is that the data is limited in it’s information.

Reorganizing these kinds of into a correct series of stream tables is not hard in that it takes expansion into

drop down selections for what the attributes would be. This database would be constrained to the existing

facts/data types listed in the menu yet expandable afterwards as the organization would need. The objec-

tives of this database environment would be a standardized method of showing this information very easily

to the consumer with insight methods also becoming standard (Morris, 2009).

The scope of these databases are streamline the display and insight of three major financing and accounting

statements used by Berry’s Irritate Blasters. The boundaries would be simple, utalizing just the existing infor-

mation whilst expanding into more than a total and data currently shown by this provider but forcing the

databases standardized in order that future info can be went into and build new arguments. This newspa-

pers is not to ever re-invent the wheel, but for create a standard series of trestle tables to display precisely

what is currently being intended for data as of this company.

It will have three trestle tables created for this provider. The trestle tables would be: Profit Statement, “bal-

ance sheet”, and Earnings Statement because these are the existing reports made by this provider (Group,

2009). For Profit Statement there are lots of attributes. The first can be ExpenseName and would be a per-

sona based info type. This might include titles of expenses such as rent, fuel, etc . The second characteristic

would be ExpenseType, meaning either direct or indirect expenditure and set up as a logical data type. The

next attribute would be MonthIncurred, a charter data type. The fourth would be Division, meaning which

usually department is responsible for this expenditure and also a personality type. The fifth characteristic

would be Cost, a number data type representing homes cost received. A possible more attribute can be Em-

ployeeName, a personality type that may explain which will employee is liable for said expense with a fol-

lowup attribute of EmployeeCost, a numeric info type which will states the retail price at that time that em-

ployee is liable for.

The second stand would be “balance sheet”. With the first of all attribute being character type called Asset-

Name. The following function would be AssetType, being a rational data type asking for Current or Fixed as-

set. The next would be Month, a character type asking for the month incurred and the subsequent attribute

would be Value, a data type symbolizing the actual cash value. This Month/Value set up would continue for

all 12 months for a total of 16 attributes with this portion. A secondary and optional table, in the event not

merely installed onto the main entity, is perfect for Liabilities with numeric data types meant for Payroll-

Taxes, AccountsPayable, and the individual Months associated with them. A following optional table, in the

event not section of the main linen, would be Stockholder’s Equity with CommonStock, Retained Earnings,

NetIncome being attributes of numeric value separated by Months and a final total with TotalEquity.

The third stand is Earnings from Functioning Activities. Dividing the actual PDF FORMAT into 3 tables pro-

duces a more efficient record. The first function would be a number data type named NetIncome, and the

second Decrease/IncreaseAR which has a numeric info type. Your third would be Decrease/IncreaseLiabliti-

ies and also a number value. The fourth would be NetCashFlowOP with a numeric data type. What is the

fifth credit is Month and will be a character type, inserted between each of the earlier attributes to get a to-

tal of 24 real attributes.

The fourth and 5th table will follow the earlier table’s design. Month getting between all the attributes for

being listed. Earnings from Investment Activities is normally fourth with CapitalExpenditures