Having two dads offered me the choice of
contrasting points of view:
one of a rich man and one of a poor man.
Deskripsi lengkap
Full description
Deskripsi lengkap
Descripción completa
ValoresDescripción completa
ghfDescripción completa
estructuras y alteracionesDescripción completa
Descripción completa
Descripción: Guía de estudio.
Descripción completa
Descripción: TraBAJO aCADEMICO cRIMINALIDAD
incapacidad imss
Descripción completa
Assignment Brief BTEC Level 4-5 HNC/HND Diploma (QCF To be flled by the Learner ame ame of the the Lea Learrner ner ! Ede"#el o %ate of Su&mission
! !
Centre o
!
$at#h!
&nit Assessment In$ormation 'uali(#ation
! 'N in om%tin* and Systems e"eloment
)nit Code * Title
! )nit ++ %ata Anal-sis and %esign
Assessment Title * o.s /CMS0 for Pinna#le $uilders /o 1 of 10
! Contra#t Management S-stem
Learning out#omes and grading opportunities! L+ ,1:&nderstand data models and database te-hnolo*ies Learning LO121 LO123 LO12+ Out#omes L+ ,: /e able to desi*n and imlement relational database
Statement o$ +ri*inality and St%dent e-laration 6 here&-, de#lare that 6 kno7 7hat plagiarism entails, namel- to use another.s 7ork and to present it as m- o7n 7ithout attri&uting the sour#es in the #orre#t 7a-2 6 further understand 7hat it means to #op- another.s 7ork2 12 6 kno7 that plagiarism is a punisha&le o8en#e &e#ause it #onstitutes theft2 32 6 understand the plagiarism and #op-ing poli#- of the Ede"#el )92 +2 6 kno7 7hat the #onse:uen#es 7ill &e if 6 plagiari;e or #op- another.s 7ork in an- of the assignments for this program2 42 6 de#lare therefore that all 7ork presented &- me for ever- aspe#ts of mprogram, 7ill &e m- o7n, and 7here 6 have made use of another.s 7ork, 6 7ill attri&ute the sour#e in the #orre#t 7a-2 52 6 a#kno7ledge that the atta#hment of this do#ument signed or not, #onstitutes a &inding agreement &et7een m-self and Ede"#el )92 <2 6 understand that m- assignment 7ill not &e #onsidered as su&mitted if this do#ument is not atta#hed to the atta#hed2
St%dent3s Si*nat%re: 44444444444 444444444
ate:
ase st%dy Pinna#le $uilders is a #onstru#tion #ompan- undertaking various Pro=e#ts at di8erent s#ales2 Ever- pro=e#t has an allo#ated &udget that the $ene(#iar- is 7illing to spend and returns a turnover2 The follo7ing are the details have to &e stored in order to assist the operations of Pinna#le $uilders2
5roje-t
/%d*et
T%rno" er
/enef-i ary
Start date
End date
S%er"i sor
Ass%mtions: •
•
•
Ever- pro=e#t has a supervisor in #harge 7ho is identi(ed &- an Emplo-ee num&er2 All #ustomers /&ene(#iar-0 are registered 7ith Pinna#le $uilders &efore #ommen#ing a pro=e#t2 A &ene(#iar- #an have more than one #ontra#t> pro=e#t running at the same time2
TAS6S
2 E"e#ute the follo7ing S'L :ueries on -our data&ase2 For ea#h of the pro&lems sho7! ?our S'L :uer The result -ou o&tained (L+ 0.)
a2 Filter the #ustomers 7ho have made more than one pro=e#t ongoing at a time2 &2 %elete the re#ords of an- #ustomers 7ho have no ongoing pro=e#t #urrentl- /@e#ord of past pro=e#ts should &e deleted02 #2 Drite an update :uer- to update a parti#ular re#ord in the data&ase2 d2 6nsert t7o pro=e#t> #ontra#t re#ords into the data&ase 7here &oth are allo#ated the same supervisor2 2 Evaluate ho7 meaningful data has &een e"tra#ted through the use of :uertools2 E"plain 7ith e"amples2 (L+ 0.0) 12Provide suita&le test #ases and a test plan to test the data&ase2 (L+ 2.1)(L+ 2.) 112Produ#e user do#umentation to assist users in making use of the relational data&ase s-stem2 (L+ 2.0) 132E"plain ho7 veri(#ation and validation are addressed in -our data&ase2 (L+ 2.2) 1+2%is#uss the se#urit- poli#ies relevant to an- data&ase management s-stem2 (L+2.7)
+bser"ation Sheet A-ti" ity No 1
A-ti"ity
6nsert data to the ta&les
Learnin* +%t-ome (L+) LO +23
%ata manipulations
LO +23
0
/)pdate>%elete0 6mplement user privileges
% +25
2
E"e#ute triggers and stored
% +25
at e
8eedba-9 (5ass !edo)
5ossible e"iden-e L+1< &nderstand data models and database te-hnolo*ies Tas9 1 121 Criti#all- #ompare di8erent data models and s#hemas +%t-omesriteria $or 5ASS
123 Criti#all- dis#uss the &ene(ts and limitations of di8erent data&ase te#hnologies
Tas9
12+ Anal-;e di8erent approa#hes to data&ase design
Tas9 0
5a*e
8eedba-9
L+ < /e able to desi*n and imlement relational database systems 321 design a relational data&ase s-stem to meet a given re:uirement
Tas9 2
323 &uild a relational data&ase s-stem &ased on a prepared design
Tas9 7
32+ appl- a range of data&ase tools and te#hni:ues to enhan#e the user interfa#e L+0
Tas9 ;
+21 e"plain the &ene(ts of using manipulation and :uertools in a relational data&ase s-stem
Tas9 =
+23 implement a :uer- language into the relational data&ase s-stem
Tas9 > A-ti"ity 1? Tas9 @
+2+ #riti#all- evaluate ho7 meaningful data has &een e"tra#ted through the use of :uer- tools
L+2 < /e able to test and do-%ment relational database systems 421 #riti#all- revie7 and test a relational data&ase s-stem
Tas9 1, A-ti"ity 7
423 #reate do#umentation to support the implementation and testing of a relational data&ase s-stem
Tas9 1,
42+ #reate user do#umentation for a developed relational data&ase s-stem
Tas9 11
424 e"plain ho7 veri(#ation and validation has &een addressed
Tas9 1
425 e"plain ho7 #ontrol me#hanisms have &een used2
Tas9 10
rade es-ritor $or ME!IT M1 Identi$y and aly strate*ies to fnd aroriate sol%tions M123#omple" pro&lems 7ith more than one varia&le have &een e"plored M Sele-t desi*n aroriate methods te-hni%es M321 @elevant theories and te#hni:ues have &een applied
M0
5resent and -omm%ni-ate aroriate fndin*s
M+2+
A range of methods of presentation have &een
5ossible e"iden-e
8eedba-9
Tas9 = )se =oin :ueries to &ring summari;ed
re#ords
from
t7o di8erent ta&les2
Tas9 1
%o#umentation is 7ell stru#tured adhering to the formatting guidelines 7ith nonoverlapping fa#ts2
6nnovation and #reative thoughts have &een applied
8eedba-9
A-ti"ity 1<7 Bantt #hart must &e provided at the appendi" se#tion and su&mit the 7ork on time2 A-ti"ity 0? 2 )se of triggers, vie7s and stored pro#edure2