KXC253SUPmarkingscheme.docx
- 文档编号:29224999
- 上传时间:2023-07-21
- 格式:DOCX
- 页数:37
- 大小:119.27KB
KXC253SUPmarkingscheme.docx
《KXC253SUPmarkingscheme.docx》由会员分享,可在线阅读,更多相关《KXC253SUPmarkingscheme.docx(37页珍藏版)》请在冰豆网上搜索。
KXC253SUPmarkingscheme
Pages:
16
Questions:
16
THEUNIVERSITYOFTASMANIA
SUPPLEMENTARYANDDEFERREDORDINARY
EXAMINATIONSFORDEGREESANDDIPLOMAS
June2004
KXC253SoftwareDesign
Examiner:
MrR.P.Dazeley
TimeAllowed:
THREE(3)hours
Instructions:
Attemptallquestions.AnswerallthesectionAquestionsonthesheetprovided.AnswereachquestioninsectionBandSectionCinaseparatebooklet.ThereareTwo(3)sections–QuestionsinsectionAareworth5markseach.QuestionsinsectionBandsectionCareworth30markseach.Allocateyourtimeappropriatelytothesections.
Nomaterialorequipmentmaybetakenintotheexamination.
SectionA:
MultipleChoice
ThereareTwelve(12)questionsinthissection.Attemptallquestionsfromthissection.Answerthequestionsonthesheetprovided.Eachquestionisworth5marks.
Usethefollowingsequencediagramtoanswerquestions1-4
Question1
AccordingtothesequencediagramwhichclassorclasseshaveausesrelationshipwiththeStockclass.
A)Supplier.
B)RecieveStock_ViewandPurchase.
C)SystemBoundary.
D)Alloftheclasses.
E)None.
[5marks]
Question2
AccordingtothesequencediagramhowmanyoperationsdoestheSupplierclasshave?
A)1
B)2
C)3
D)5
E)15
[5marks]
Question3
AccordingtothesequencediagramhowmanyclassesarethereintheMerchandisepackage?
A)1classes
B)2classes
C)3classes
D)4classes
E)5classes
[5marks]
Question4
AccordingtothesequencediagramwhatvisibilitiesmusttheoperationssupplierCodeandupdateStockhave?
A)publicandpublic.
B)protectedandprivate.
C)privateandprotected.
D)privateandpublic.
E)privateandprivate.
[5marks]
Usethefollowingcodetoanswerquestions5-8
packagePeople;
abstractclassPerson{
protectedinttime;
publicPerson(){
time=0;
}
publicvoidwork(){}
publicvoidwork(intt){
time=t;
}
}
abstractclassEmployeeextendsPerson{
privateintrate;
publicEmployee(){
rate=4;
}
publicpay(){}
publicvoidpayRate(intrate){
this.rate=rate;
}
publicintpayRate(){
returnrate;
}
}
classLecturerextendsEmployee{
publicLecturer(){
rate=32;
}
publicLecturer(intrate){
payRate(rate);
}
publicvoidwork(){
System.out.println(“Lecturerpresents”+time+“lectures.”);
}
publicpay(){
System.out.println(“Lecturerpaid”+this.payRate());
}
}
classAdministratorextendsEmployee{
publicvoidwork(){
System.out.println(“Admindutiesfor”+time+“hours.”);
}
publicpay(){
System.out.println(“Administratorpaid”+this.payRate());
}
}
classStudentextendsPerson{
publicvoidwork(){
System.out.println(“Studiesfor”+time+“hours.”);
}
}
Question5
WhichmethodoverridesthepayRatemethod?
A)payRate()
B)payRate(int)
C)work()
D)work(int)
E)work()andpayRate()
WhileAwastheintendedcorrectansweritappearsalatechangeinthecodesegmentrenderednoneoftheaboveanswerscorrectwhichwasn’tnoticedpriortotheexam.Giveeverybodyfullmarksforthisquestionregardlessofwhatthereansweris.
[5marks]
Question6
WhichmethodoverloadsthepayRatemethod?
F)payRate()
G)payRate(int)
H)work()
I)work(int)
J)work()andpayRate()
[5marks]
Question7
Ifthefollowingprogramsegmentisrun,whatwouldtheoutputbe?
publicstaticvoidmain(String[]args){
Personp=newLecturer(17);
p=newStudent();
p.pay();
}
A)Lecturerpaid17
B)Studentpaid17
C)Administratorpaid4
D)Lecturerpaid4
E)Run-timeError.
[5marks]
Question8
Ifthefollowingprogramsegmentisrun,whatwouldtheoutputbe?
publicstaticvoidmain(String[]args){
Lecturerl=newLecturer();
l.work(3);
Personp=newStudent();
p.work(14);
Employeee=l;
p=e;
e.work(16);
p.work();
}
A)Lecturerpresents3lectures.
B)Studiesfor0hours.
C)Studiesfor14hours.
D)Lecturerpresents16lectures.
E)Lecturerpresents0lectures.
[5marks]
Usethefollowingdatabasetablesanddatatoanswerquestions9-12
CREATETABLEstudent(
idsmallintprimarykey,
namevarchar(30),
dobdate,
suburbvarchar(100)
);
CREATETABLEunit(
namevarchar(100)primarykey,
roomsmallint
);
CREATETABLEenrolledIn(
student_idsmallint,
unit_namevarchar(100),
marksmallint
);
ALTERTABLEenrolledInADDCONSTRAINTFK_student_enrolledIn
FOREIGNKEY(student_id)REFERENCESstudent(id);
ALTERTABLEenrolledInADDCONSTRAINTFK_enrolledIn_unit
FOREIGNKEY(unit_name)REFERENCESunit(name);
ALTERTABLEenrolledInADDCONSTRAINTPK_enrolledInPRIMARY
KEY(student_id,unit_name);
SQL>select*fromstudent;
id|name|dob|suburb
----+-----------------+------------+-----------------
1|JohnSmith|1983-01-24|Kingston
2|AndreaJones|1984-11-01|SandyBay
3|ScottCopperman|1979-03-27|Hobart
4|SarahWilliams|1984-09-05|SandyBay
SQL>select*fromunit;
name|room
------------------------+------
SoftwareDesign|26
AlgorithmsandMetrics|321
ComputerSecurity|121
SQL>select*fromenrolledIn;
student_id|unit_name|mark
------------+------------------------+------
1|SoftwareDesign|65
1|ComputerSecurity|86
2|ComputerSecurity|43
3|ComputerSecurity|61
3|AlgorithmsandMetrics|54
3|SoftwareDesign|77
4|AlgorithmsandMetrics|82
Question9
Whichquerywillgiveaclasslistofallthestudentsthatarestudyingtheunit“SoftwareDesign”?
A)SELECT*FROMstudentWHEREunit_name=‘SoftwareDesign’;
B)SELECT*FROMstudentWHEREid=(selectstudent_idFROMenrolledInWHEREunit_name=‘SoftwareDesign’);
C)SELECT*FROMstudenthavingid=(selectstudent_idFROMenrolledInWHEREunit_name=‘SoftwareDesign’);
D)SELECT*FROMstudentwhereidin(selectstudent_idFROMenrolledInWHEREunit_name=‘SoftwareDesign’);
E)SELECT*FROMstudenthavingidin(selectstudent_idFROMenrolledInWHEREunit_name=‘SoftwareDesign’);
[5marks]
Question10
Whichquerywillproducethefollowingoutput?
unit|avg
------------------------+---------------------
SoftwareDesign|71.0000000000000000
AlgorithmsandMetrics|68.0000000000000000
ComputerSecurity|63.3333333333333333
A)SELECTunit,markasavgFROMenrolledIn;
B)SELECTunit,sum(mark)FROMenrolledIn;
C)SELECTunit,avg(mark)FROMenrolledIn;
D)SELECTunit,avg(mark)FROMenrolledInORDERBYavg;
E)SELECTunit,avg(mark)FROMenrolledInGROUPBYunit;
[5marks]
Question11
WhichofthefollowingstatementswillenrolAndreaJonesinSoftwareDesignandawardherthemark81?
A)INSERTINTOenrolledInVALUES(2,‘SoftwareDesign’,81);
B)INSERTenrolledInVALUES(2,‘SoftwareDesign’,52);
C)INSERTINTOenrolledInVALUES(‘AndreaJones’,‘SoftwareDesign’,81);
D)INSERTenrolledInVALUES(‘AndreaJones’,‘SoftwareDesign’,81);
E)Noneoftheabove.
[5marks]
Question12
Whatdoesthefollowingquerydo:
SELECTstudent.nameasst_name,unit.nameasun_name,unit.roomFROMstudent,unit,enrolledInWHEREstudent.id=enrolledIn.student_idANDunit.name=enrolledIn.unit_name;
A)Createsatableshowingwhichunitsandroomseachstudentmustattend.
B)Selectsdetailsofwhichunitsandroomseachstudentmustattend.
C)Createsatablelistingallthestudents,unitsandroomnumbers.
D)Selectsdetailsofallthestudents,unitsandroomnumbers.
E)Nothing;ithasasyntaxerror.
[5marks]
SectionB
ThereareTwo
(2)questionsinthissection.AttemptBOTHquestions,putyouranswersforeachquestioninaseparatebooklet.Eachquestionisworth30marks.BothQuestionsinthissectionarebasedonthematerialcoveredbyassignment1and2
Usethefollowingrequirementsdocumenttoanswerquestionsinthissection.ThisRequirementsDocumentisidenticaltotherequirementsdocumentgiveninassignment1.
Introduction
UTasTicketsisalocalbusinessspecialisinginhandlingbookingsforseveraltypesofevents.Theypersonalisetheirservicebykeepingcustomerrecordsenablingthemtotargetmarketing,butalsomoreimportantlytoenablecustomerswithanexistingaccounttomanageandcreatetheirownbookings.
Eventsmaybeheldatanumberofdifferentvenues,andnewvenuesmayalsobeused.Someeventsarerestricted;forexample,ifalcoholisonsaleonlypatrons18yearsofageorovermayattend.Thereareroughlytwodifferenttypesofvenues;sportingvenueswhichonlyhaveasingletypeofseating,andtheatricalvenueswhichofferfirst-classandsecond-classseats.Duetounforseencircumstanceseventsareoccasionallycancelledorpostponed,andinthesecasesitisdesirableforallcustomerstobenotified.
UTasTicketswouldlikeastate-of-the-artelectronicsystemtoenablethemtoeasilyenterthedetailsofcomingacts,managecustomerdetails,andalsoforcustomerstomanagetheirownbookingsatavailableelectronicterminals.
Database
ThedetailsofalleventshandledbyUtasTicketswillbestoredinanpostgreSQLdatabase.Theyalsorequirealltheircustomerstobestoredinthesamedatabase,formarketingpurposesandtoenablethemtonotifyallcustomersifthereisanychange(suchasapostponementorcancellation)toaneventtheyhavepurchasedticketsto.Forsecuritypurposes(suchasloggingin),staffdetailswillalsobestoredinthedatabase.Staffdetailswillbeenteredmanually,howevertheywillrequireaninterfacetoentercustomerdetails.
CreatingVenues
Staffshallbeabletoenterthedetailsofanewvenue.Theyshallbeabletocreateanentryinthedatabasewiththefollowingdetails:
∙Venuename;
∙Location;
∙Typeofvenue(sportingortheatrical);
∙Numberof
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- KXC253SUPmarkingscheme