IT IT
Ai
Du
Pr
ECH 1006/IT
ECH 1006/IT
m: To give yo techniques
ue Date: Monday of
roject Specif Alan Count practice sp started the other acco of significa that it cope At the mo client, the the practic contact nu informatio are simply an ABN, w of operatin number is The client business s trader, ind business a own, a clie set up to d entity sits duties and circumstan Sectors ar include ret categories
TECH 5006
TECH 5006
Develo
ou practica s.
f Week 7 (se
fication ting, Edwar pecialises in e practice in ountants and ant growth a es better w
ment, when client's info ce and clien umber, ABN n is optiona salary and whilst others ng their bus allocated to
is the lega structure ty ividual, priv s a private ent record w deal with th within ano d compiles nces, there a
e the broa tail, constru are created
Database M
Database M
opment of
al experienc
ee Course D
d Quals and taxation, a n 2005 and d office staf and have co ith their wo
n a client tu ormation is nt, the client N, TFN, stru al based on wage earne s are compa siness. Once o the client.
l entity bei ype. A clien vate compa company, a would be cr e affairs of other but th returns fo are two clie
d categorie uction, finan d and the p
Managemen
Managemen
A f an ER Di
ce in using
Description f
d Peter Rofi uditing and it has grown ff. Alan, Edw ome to you orkflows and
urns up for referenced t is asked to ucture, sec the type of ers looking anies requir e the releva .
ng dealt wi nt record c any, partne and they w reated for th each of the his is not o or a self-ma ent records
es that allo ncial service ractice wou
nt Systems –
nt Systems –
Assignme iagram an Weight 2
g Entity-Re
for further
t are in par d financial a n to now em ward and P to help the d supports
a schedule d using the o complete ctor, service f client and for assistan ring advice ant informat
ith by the p an only ha rship and t want their co hat private e individuals obvious e.g anaged sup - the individ
ow groupin es, hospital uld like to re
– Assignme
– Assignme
nt 1 nd Databa 0%
lationship a
dates and t
tnership in dvice for sm mploy 25 pe eter believe m redevelo future grow
ed appointm client’s nam their detai e) on a clie area they o nce to comp and assista tion is obta
practice an ave one str trust. If for ompany’s ta company a s. There are . where the perannuatio dual and th
g of clients ity and man ecord these
nt 1 Sem3 2
nt 1 Sem3 2
se Implem
and Relatio
imes).
an account mall to med eople. Thes e the practic op their Clie wth opportu
ment or wh me. If it is t ls (i.e. name ent informa operate in. F plete tax ret nce with th ined for a n
d clients ar ucture type example, t ax return co and separate circumstan e practice p on fund for e superann
s for repor nufacturing e with their
2014 (20142
2014 (20142
mentation
onal Datab
ting practice ium sized c se employe ce is heade nt Billing (C unities.
hen an acco the first co e, address, ation form. For example turns and w he many dif new client, a
re created b e. Example two individ ompleted a e client rec nces though performs su r an individ uation fund
rting purpo g. Occasiona code and d
27)
27)
n
ase model
e, CQR. The lients. They es include d for a perio CB) system s
ountant visit ntact betwe contact nam Some of t e, some clie would not h fferent aspe a unique cli
based on th s include s uals operat as well as th cords would h where a le uperannuat dual. In th d.
oses. Examp ally new sec description i
ling
y
od so
ts a een me, this ents ave ects ent
heir sole te a heir d be egal tion ese
ples ctor in a
CRICOS Provider No. 00103D
separate ta more secto taxation, fi like to be a The practic purposes o informatio CB system employee may have employee another em supervisor based on q particular accountant each empl data. All contact phone call work cond Profit and reviewing billable to time they w as a categ occasional in multiple time. They against non case separ All employ individual yearly by A ? the ex ? the ov incurr ? their h Alan, Edwa employee
D ITECH100
able. They ors. Service inancial pla able to reco
ce has a se of billing, th n is recorde m, all emplo type, a cha multiple e type e.g. a mployee is highest in qualification employee t t. These qu oyee but th
t with the s to and fro ducted on b Loss and legislation the client. work on a p gory of wor ly have new es of this am y always en ne, one or m rate billing r
yees as well is billed to Alan, Edwar xperience a verheads of red as part o hoped for p ard and Pe based on th
6/5006 Database Ma
would also es are the b nning, corp rd that a cli
parate Hum hey record ed based on oyees inclu arging/billin mployment accountant, responsible the hierarc ns. An emp type e.g. em ualifications hey have ha
client - app om the clien behalf of th Balance S or commu All staff bi particular cl rk (these ar w reference mount. Wh nd any ope many client records wou
as Alan, Ed the client. T d and Peter nd salary of f the practic of the runn profit and di eter genera he employe
anagement Systems
like to be broad categ porate advic ient must u
man Resourc specific bill n the uniqu uding Alan, ng rate (see t domains e administra e for superv chy is able t ployee may mployees ca should be ad problems
pointments nt, auditing e client - co heet statem nicating wi ll/charge in ient by ente re from a r s added) an en they ha ened charge ts. Two or m uld be creat
dward and The chargin r. Their revie f employees ce (some co ing of the p istributions lly follow a ee's salary a
- Assignment 1 Spe
able to rec gories that ce and supe se at least o
ces (HR) sys ling details e employee , Edward a e below) an e.g. taxatio ator. The au vising and s to sign-off. F y have many annot have chosen fro s in their cu
s at the clie g and stockt ompleting t ments for th statutor n spans of 1 ering a star reference s nd must cha ave finished es on the s more employ ted for each
Peter have ng rate is an ew is based s; osts are not practice); an to themsel a process o and then m
cification Sem3 2014
cord that a the practic erannuation one service
stem record about an e e number as and Peter a nd an audit on, auditing udit supervi signing off Further det y qualificati a public pr om a set rat urrent syste
ent or at th taking at th tax, supera the various ry authoritie 15 minutes. ting date an et common arge a mini d their parti same day. A yees could h employee.
a charging n hourly figu d on conside
directly att nd lves as part of determin ultiply by th
4 (201427)
client may e offers. Ex n administra but may us
ding all emp employee w ssigned in t are given a t supervisor g, superann isor status on the aud tails are rec ons and th ractice cert ther than b m with ens
he practice e client - is nnuation o s legal ent es on beha That is, th nd time for n to many mum time o cular activi An employ work togeth .
rate which ure. The ch eration of:
ributable to
ners. ning the ho he same fac
y operate in xamples inc ation. The p se a numbe
ployee deta within the C the HR syste an employm r identifier. nuation but refers to w dit of a clien corded for e ey may be tificate unle eing separa suring the in
's offices, l s billable to or BAS retur tities used alf of the c hey record t the work th accounting of 15 minut ity, they key yee can wo her on a job
is the rate arging rates
o the client
ourly charg ctor for all t
Page
n none, one clude auditi practice wo r of service
ails but for CB system. T em. Within ment doma An employ only has o whether or nt i.e. only each employ specific to ess they are ately keyed ntegrity of t
etters, ema the client. rns, prepar by a clien lient - is a the amount hey do, as w practices a tes and cha y in an end rk for and b and in suc
at which e s are review
but are
e/bill rate to arrive at
e 2 of 5
e or ing, ould s.
the This the ain, yee one not the yee the e an for this
ails, All ring t/s, also t of well and arge ding bill ch a
ach wed
per the
CRICOS
Provider No. 00103D
final charg as noted b As well as incurred on At the end the previo itemised, a for the cli accounts a payment o existing Ac respect to As part of t following s ? For ne rather to be catego ? Alan, data r provid the pr offerin ? Up to new r detail record this fu ? The p to und legal s oppor group a case and th there You are req the model
D ITECH100
e rate for th elow they w
charging em n behalf of
d of each m us month f any work or ient is calc are also pr of a numbe ccounts Pay the monthl
their intend situations: ew and exis r than allow assigned to ories they c Edward and recorded ag ded by the p ractice to pe ng other se now the pr rates are key in the AP s d the rate p unctionality ractice wou derstand ho structures. T rtunities wit ps the three e the two in he private c should be a
quired to de into a relat
6/5006 Database Ma
he employe would like to
mployee tim the client e
month the p for a client r on-costs p culated (sto roduced an er of differ yable (AP) ly account r
ded improve
ting clients, wing for pred o the client. could identif d Peter belie gainst the cl practice. Ge erform and rvices the c ractice has n yed in, the h ystem. Alan per employe y to be in th uld like som ow many cli This will ass th existing c clients men dividual clie company cli a relationsh
esign (using tional mode
anagement Systems
ee. You are o record the
me, the pra e.g. lodgeme
practice run is obtained performed f ored) and i nd an ama rent billing system. Yo run and this
ements, Ala
, the sector defined cat Alan, Edwa fy growth a eve there is ient is litera enerally wha because of client would not been ab historical re n, Edward a ee against a e CB system e idea of ho ents they h sist them w clients. For ntioned ear ent records ent record w hip link attri
g an E-R diag el, and asses
- Assignment 1 Spe
not expecte e rate and t
ctice also o ent fees, pe
ns its month (stored pre for the clien included on lgamated a clients. Al You do not s description
an, Edward
r they opera egories to b ard and Pete areas with in s similar sco al and does at is record f this the pr d benefit fro ble to keep ecords are lo nd Peter wo time perio m; ow clients 'f have that are ith understa r example th rlier – the p would ‘poi would link t bute that a
gram) an en ss the norm
cification Sem3 2014
ed to provid time period
on-charges f enalties or f
hly account eviously), a nt are also i n the acco account sen l these pro need to d n is provide
and Peter w
ate in is reco be used and er believe if ndividual cli ope to offer not align w ed is the 'se ractice may om; historical e ost - as that ould like thi d for which
fit together e related in anding if th hey would li rivate comp nt’/‘link’ to to no others llows this li
ntity-relatio mal form of e
4 (201427)
de the algo for which i
for services ines.
t run. The o ny paymen temised an ount. In som nt to an in ocesses are o anything ed as backgr
would like t
orded litera d therefore f they could ients and w add-on ser with the cate ervice' the c be unclear
mployee ch t informatio is to change the rate ap
'. That is the some way ey have mis ike to be ab pany and th o the private s. In each cl nking.
onship mode each schem
rithm for th it applies.
s or costs th
outstanding nts or credit d an outsta me cases, ndividual re e handled b in this ass round.
heir system
ally against e allow multi d correctly r within sector rvices to clie egorisation client origin or missing
harging rate on is not kep e so that it i pplies. They
ey would lik but are sep ssed out on ble to run a he two indiv e company lient record
el of the pro ma.
Page
his process
hat are dire
g balance fr ts received anding bala summaries esponsible by a separa signment w
m to handle
each client iple categor ecord these rs themselv ents but the of services nally contact out on
s - when th pt to that s possible t y would like
ke to be abl parated by n any service report that viduals. In su client recor d therefore
oblem, conv
e 3 of 5
but
ctly
rom are nce s of for ate, with
the
ries e ves; e
ted
e
to
e
e uch rd
vert
CRICOS
As
1. 2. to 3. 4.
5.
6.
7.
Provider No. 00103D
ssignment S You should specified w The design
A com An ap about the A tabl An en
The Relatio a. b. c. The
Norm a. b. c.
A bibliogr resources
Your assig for the Pre
http://www
D ITECH100
Submission d produce a within this d n document
mpleted cop ppropriate t assignment le of conten tity relation a. all entit b. primary c. d. assum for tho e E-R should
onal data st relation (t attribute primary a e data struct alisation of dependen the level o the reason
raphy, in A s have been
gnment sho esentation o
w.ballarat.e
6/5006 Database Ma
single pdf f document. Y should con
y of the SIT title page t t. nts and auto n (E-R) diagr ties, relatio y (underline card ptions you se not men d be comple
tructures th table) name (column ) n nd foreign tures should
relations w ncy diagram of Normalis ns for any r
APA format, used pleas
ould be co of Academi
edu.au/gene
anagement Systems
file, created Your lecture ntain:
E Assignme that include
omatically ge ram that mo nships (incl ed) and fore inality and have mad ntioned or c eted using th
hat translate es, ames and f keys identif d be shown
which identif m for each re ation achie elation that
containing se indicate t
ompleted a c Work. Th
eralguide
- Assignment 1 Spe
d using Wor er will provid
ent Covershe es an ackno
enerated pa odels the p uding name eign (italic) participatio de, e.g. how lear in the b he standard
e your E-R d
field types (a fied; using the s
fies: elation eved for eac t is maintain
g all resour this appropr
according t is is availab
cification Sem3 2014
d, containin de details o
eet. owledgeme
age number roblem whi es) and attr keys identif on (optional w you arri business de ds of this co
diagram wh
as required
tandards of
ch relation; ned NOT in
rces used to riately.
to the Un ble online at
4 (201427)
ng all of the of how the f
ent of all st
rs. ch includes ibutes; fied; l / mandato ved at the escription, e urse (crow’
ich includes
by WAMP)
f this course
3NF.
o complete
iversity of t the followi
e requireme file is to be s
tudents you
s:
ory) symbols e cardinality etc. ’s feet).
s:
),
e.
e the assign
Ballarat G ing web add
Page
nts as submitted
u have spo
s; and y/participat
nment. If
General Gu dress:
e 4 of 5
ken
tion
no
uide
CRICOS
As
As E
R N R D
Provider No. 00103D
ssessment C
1. How c 2. E-R di foreig 3. Relati 4. Norm schem 5. Conve submi
ssignment 1
ER Diagram
Relational Str Normalizatio Relational Sc Documentati
D ITECH100
Criteria
clear and w iagram: adh gn keys, app onal data st alisation: a ma in the no ersion of E-R itted with a
1 – Marking
ructure n hema ion
6/5006 Database Ma
ell-presente herence to propriate en tructures: c ppropriate ormal form R diagram to appropriate
g Overview
anagement Systems
ed your sub our standa ntities, relati correct and interpretat you conside o relational tables, colu
- Assignment 1 Spe
bmission is. rd, assump ionships, an meaningful tion of each er optimal. l schema: sc umns, and p
cification Sem3 2014
tions made nd attribute l translation h normal fo
chema is a c primary key
Totall
4 (201427)
e, inclusion s. n of your E-R orm, argume
correct tran s.
of correct
R diagram. ents for lea
nslation of th
Page
primary an
aving the
he E-R
/ 50
/10 /20 /15 /5
/100 /20%
e 5 of 5
d
GET ANSWERS / LIVE CHAT