ISYS2047 –Information Systems Solutions and Design – Semester 1 2017 © France Cheong 2014-2017 1 Assignment 1 Developing a Hotel Room Reservation Information System – Initial Iteration Note: This is an individual assignment. 1 Due date – Week 7 (Tues 11 and Wed 12 April Tutorial Labs 2017) This assignment is to be demonstrated to your tutor in the lab of week 7 and a zipped copy of your work submitted to Blackboard. Please ensure that your work is accompanied by a duly signed assignment cover sheet (Google “RMIT assignment cover sheet if you don’t know where to find one). 2 Marks The assignment is worth 15% of the course marks. 3 Background A client has hired your software development company to develop an information system for their customers to make room reservations. In assignment 1, you are required to create and populate the database as well as implement the code to perform basic CRUD operations on one table in the database. 4 Requirements At this stage of the project, the data requirements have already been identified and modelled as an Entity-Relationship diagram (ERD) as shown next.ISYS2047 –Information Systems Solutions and Design – Semester 1 2017 © France Cheong 2014-2017 2 You are required to perform the following tasks: 1. Implement the ERD provided as a Microsoft Access Database. You are required to use the appropriate data types for the fields and define appropriate primary and foreign keys. Populate the Booking, Customer and Room tables with 5 records in each table using MS Access. 2. Create a VB project with a single form to insert and retrieve data from the Booking Table. 3. Write code to validate and insert data in the booking table. You are required to use data controller and validation classes as well as hashtables when writing the code. I suggest that you first adapt Task 4.5 as a start to capture data without validation. Once you are comfortable with the data capture part, you can adapt Task 4.6 to include validation (or you might choose not to perform validation – there’s a small penalty for not performing validation). 4. Use a dropdown box for selecting rooms and customers (hint: you need to do Task 5.1 and Task 5.5 and preferably Task 5.2 as well to enhance the functionality of Task 5.5). Date manipulation tips 1. If you use a DatePicker for picking dates on your data entry forms, you should use Date/Time as MS Access database type for the dates in question. 2. If you use Date/Time data types in your MS Access database, when executing SQL code (from either MS Access or Visual Basic), you should use a string delimited by hash signs rather that double quotes. Example: SELECT * from service where date_serviced = #yyyy/mm/dd#; Debugging tips You may want to look at Task 6.1 if you want to gain advanced knowledge on how to debug your code. Advanced debugging knowledge is not required for assignment 1 if you are careful enough to avoid typos and respect the case sensitivity of keys/names in hashtables. However, you may wish to gain advanced debugging skills at an early stage in the course.ISYS2047 –Information Systems Solutions and Design – Semester 1 2017 © France Cheong 2014-2017 3 You are strongly advised to use programing concepts taught in the course to implement the system, more specifically: hashtables, lists, modularization, and object-oriented techniques. 5 Software Architecture Your VB project should contain the following components: 1. Your MS Access database Hotel.accdb in the bin folder of your project 2. A single form named frmBooking.vb 3. A data controller class named BookingController.vb to handle all data access logic i.e. SQL queries 4. A validation class named Validation.vb to handle all validation logic 6 Deliverables/Submissions The deliverables for this assignment are: 1. A zipped file of your code and assignment cover sheet submitted to Blackboard before the start of the lab class. 2. Project demonstration and code review with you tutor during the lab class of week 7.ISYS2047 –Information Systems Solutions and Design – Semester 1 2017 © France Cheong 2014-2017 4 SCHOOL OF BUSINESS IT & LOGISTICS Assignment 1 – Marking Guide Student Name: Student no: Max Marks Actual Marks Comments 1. Access database implemented with correct data types, primary and foreign keys and customer, booking and room tables populated with 5 records in each table 20 2. Created a data capture form and wrote code for validating and inserting data in table booking 50 3. Implemented a dropdown box for selecting customers in the booking form 15 4. Implemented a dropdown box for selecting rooms in the booking form 15 Deductions: 1. No data controller & validation classes 2. Did not use Hashtables and Lists 3. Code not modular 4. Did not switch Option Explicit and Strict on 5. No comments in the code 6. Poorly designed form 7. Cannot explain operation of the code Total 100