数据库管理系统概述英文版课件：3 project

1、COMP231 ProjectProject SpecificationPrepared by Raymond WongPresented by Raymond WongCOMP231 Project1OutlineProgramming DetailsDeadlineHand inWorkflowGrading PolicyStubsDemoProject TopicImportant PointSampleCOMP231 Project2Group Forming1 or 2 members per groupPlease send an email containing the foll

2、owing information of each member to our tutor, Grace, to form a group. student IDstudent nameemailCOMP231 Project31. Programming DetailsLanguage: Java (with JDBC)Java Version: Java SDK 6.0 (Version 1.6.0)Testing Platform: LinuxCOMP231 Project42. Deadline17 Sept, 2009 3:00pm28 Sept, 2009 3:00pm13 Oct

3、, 2009 3:00pm16 Nov, 2009 3:00pmPhase 1Phase 2Phase 3Phase 4COMP231 Project53. Hand inER Diagram (hard-copy)A suggested answer released after the deadlineDatabase Application (soft-copy)Insert data into DB Programming in Java and JDBCRelational schema and the Proof of 3rd normal form (hard-copy)A su

4、ggested answer released after the deadlineSample Data and Data Reader released after the deadlineSystem Interface with Stubs (i.e. Your Database Application with Stubs) (soft-copy)Programming in JavaPhase 1Phase 2Phase 3Phase 410%20%20%50%COMP231 Project64. WorkflowPhase 1 DeadlinePhase 1Phase 2Phas

5、e 3Phase 4Phase 2DeadlinePhase 3DeadlinePhase 4DeadlinetodayJava Program (Stubs)Relation and 3NFJava Program (Full)ERSuggested ER ReleasedSuggested Relation and 3NF ReleasedData Set and Data Reader Released No Late Submission is allowed for Phase 1 and Phase 3Late submission is allowed for Phase 2 a

6、nd Phase 4COMP231 Project75. Grading PolicyPhase 4The time for the insertion of DB should NOT be too slow Within 10 seconds is OK.More than 10 seconds insertion may lead to mark deduction!Same for query from the database Possible Reason: In JDBC, some students call the method of “Opening Connection”

7、 (i.e. getConnection) many timesThe method “getConnection” should be called once.50%COMP231 Project86. StubsER Diagram (hard-copy)A suggested answer released after the deadlineDatabase Application (soft-copy)Insert data into DB Programming in Java and JDBCRelational schema and the Proof of 3rd norma

8、l form (hard-copy)A suggested answer released after the deadlineSample Data and Data Reader released after the deadlineSystem Interface with Stubs (i.e. Your Database Application with Stubs) (soft-copy)Programming in JavaPhase 1Phase 2Phase 3Phase 410%20%20%50%COMP231 Project96. StubsTop-down design

9、 in software engineering cyclePropertyCan be executedDoes something to tell you that it can be executed successfullyDoesnt (yet) do the details of what you really want it to doHas the structure of how you want it doneCOMP231 Project106. StubsNeed to refine at the end of the software engineering cycl

10、eIn this project,No JDBC is required in Phase 2No Data Reading Part is required in Phase 2Advantages:Implement the system interface in the early stageFocus on the Java implementation in Phase 2Focus on the REAL implementation (JDBC) in Phase 4Allow the new learners to write simple Java programsCOMP2

11、31 Project116. Stubs - Arithmetic OperationsArithmetic OperationsAdditionSubtractionMultiplicationDivisionCOMP231 Project126. Stubs - Arithmetic OperationsArithmetic OperationsAddition/ to add two numbers, no1 and no2public int addition(int no1, int no2)/ temporarily, we always return 12 return 12;C

12、OMP231 Project136. Stubs - Arithmetic OperationsArithmetic OperationsSubtraction/ to subtract number no1 from number no2public int subtraction(int no1, int no2)/ temporarily, we always return 13 return 13;COMP231 Project146. Stubs - Arithmetic OperationsArithmetic OperationsMultiplication/ to multip

13、ly number no1 by number no2public int multiplication(int no1, int no2)/ temporarily, we always return 14 return 14;COMP231 Project156. Stubs - Arithmetic OperationsArithmetic OperationsDivision/ to divide number no1 by number no2public int division(int no1, int no2)/ temporarily, we always return 15

14、 return 15;COMP231 Project166. Stubs - Arithmetic OperationsArithmetic OperationsInterface / to display the arithmetic menupublic static void main(String args)/ here, we need to implement for the flow/ display the menu/ allow the user to choose one of the functions in the menu/ check the input and c

15、all the correspondence functionCOMP231 Project176. Stubs - BankBankCustomer Interface Bank Interface Display Balance Display Record Address Update Given an account no,display the balanceGiven an account no,display the transaction recordsGiven an account no and the address (to be updated), update the

16、 address of the customer who has that accountCOMP231 Project186. Stubs - BankBankCustomer Interface Display Balance Given an account no,display the balance/ to display the balance of the account with account nopublic void displayBalance(String accountNo)/ temporarily, we always display 1000System.ou

17、t.println(“Balance:”+1000); return;COMP231 Project196. Stubs - BankBankCustomer Interface / to display the transaction recordspublic void displayRecord(String accountNo)/ temporarily, we always display two records/ Record 1System.out.println(“Date:”+”2009-09-12”);System.out.println(“Debit:”+350);/ R

18、ecord 2System.out.println(“Date:”+”2009-09-13”);System.out.println(“Debit:”+350);return;Display Record Given an account no,display the transaction recordsCOMP231 Project206. Stubs - BankBankBook Interface / to update the address of the customer who has that accountpublic void addressUpdate(String ac

19、countNo, String address)/ temporarily, we do nothing except prompting a messageSystem.out.println(“The update is successful!”);return;Address UpdateGiven an account no and the address (to be updated), update the address of the customer who has that accountCOMP231 Project216. Stubs - BankBankInterfac

20、e / to display the bank interfacepublic static void main(String args)/ here, we need to implement for the flow/ display the menu/ allow the user to choose one of the functions in the menu/ check the input and call the correspondence functionCombineCOMP231 Project227. DemoDuration: about 20 minsExecu

21、te on two kinds of data setsProvided data setAnother unseen data setCOMP231 Project237. DemoEach group can use at most one coupon regardless of the total number of members in the group.Each coupon can be used for one checking stepPlease bring the coupon to the demonstration.COMP231 Project248. Proje

22、ct TopicAn ordering system for a supermarket All the information on items, customers and purchase information are stored and accessed onlineCOMP231 Project258. Project TopicItemIIDItem NameUnit PriceNo of Units AvailableCOMP231 Project268. Project TopicCustomerCustomer IDCustomer NameDelivery Addres

23、sCredit Card NoCOMP231 Project278. Project TopicOrderOrder IDCustomer IDOrder DateItems OrderedChargeDelivery Status (Y/N)COMP231 Project289. Important PointE.g. Partial Match or Exact MatchInput: “ABC%”, Partial Match: “ABC Milk” may be the outputInput: “%ABC%”, “%ABC” or “ABC%”Exact match: “ABC”CO

24、MP231 Project2910. SampleER Diagram (hard-copy)A suggested answer released after the deadlineDatabase Application (soft-copy)Insert data into DB Programming in Java and JDBCRelational schema and the Proof of 3rd normal form (hard-copy)A suggested answer released after the deadlineSample Data and Dat

25、a Reader released after the deadlineSystem Interface with Stubs (i.e. Your Database Application with Stubs) (soft-copy)Programming in JavaPhase 1Phase 2Phase 3Phase 410%20%20%50%COMP231 Project3010. SamplePhase 1 and Phase 3ER-diagram, Relation and proof of the 3rd normal formE.g. Student takes a co

26、urseStudentStudent ID UniqueStudent NameCourseCourse ID UniqueCourse NameStudentStudent IDStudent NameCourseCourse IDCourse NameCOMP231 Project3110. SampleE.g. Student takes a courseStudentStudent IDStudent NameCourseCourse IDCourse NameTakeAssumption:Each student takes at least one courseEach course is taken by at least one studentSchemaStudentCourseTake(Student ID, Student Name)(Course ID, Course Name)(Student ID, Course ID)Phase 1 and Phase 3ER-diagram, Relation and proof of the 3rd normal formCOMP231 Project3210. SampleE.g. Student takes a courseAssump