Victorian Institute of Technology Pty Ltd ABN: XXXXXXXXXXRTO No: XXXXXXXXXXTEQSA ID: PRV XXXXXXXXXXCRICOS Provider Code: 02044E S1, 2019 ITAP3011 Page 1 of 3 Project (25%) Due date: Fri Lesson 12...

explained


Victorian Institute of Technology Pty Ltd ABN: 41 085 128 525 RTO No: 20829 TEQSA ID: PRV14007 CRICOS Provider Code: 02044E S1, 2019 ITAP3011 Page 1 of 3 Project (25%) Due date: Fri Lesson 12 before 5:00PM Submit your work on Moodle in Project folder 50% deduction for Late Submission within one week 0 mark for Late Submission more than one week 0 mark for duplicated Submission or Shared Work You will be marked based on your submitted WORD file on Moodle. You are most welcome to check your file with your lab tutor before your submission. No excuse will be accepted due to absence from lecture or lab classes where details of lab requirements may be given. Please make sure that you attend Lec/Tut EVERY WEEK as low attendance may result in academic penalty or failure of this unit. Student ID: Full name: Victorian Institute of Technology Pty Ltd ABN: 41 085 128 525 RTO No: 20829 TEQSA ID: PRV14007 CRICOS Provider Code: 02044E S1, 2019 ITAP3011 Page 2 of 3 Objectives: This project aims to assess the knowledge, skills and application of knowledge/skills imparted in the unit through a hands on project. The concepts tested in this are: • Ability to develop a Windows Based application consisting of User Interface, Business Logic and Database • Knowledge of .NET programming • Skills in LINQ and Entity Framework Project Scope: Functional Requirement: Prepare a small University Library module that would help the librarian to issue books to students. The following database tables are recommended for the system: • Student (StudentID, StudentName, Course, Department, Address, Phone, BookQuota) • Book (BookID, Title, ISBN, Author Names, BookPrice) • Borrow (StudentID, BookID, BorrowDate, DueDate) The following screens may be designed • Screen for Editing Book Detail • Screen for Editing Student Detail • Screen for Librarian to issue a book to a student. • Screen for viewing all the Books currently borrowed. It should have variations in how the data can be queried and for each of this appropriate LINQ or Lambda has to be done Tasks: 1. Create a database with the mentioned tables. a) You should design the table schema using appropriate data types and keys b) You should populate test data in the tables 2. Create Entity Data Model for the database. 3. Design layout (windows forms) for the above four screens Victorian Institute of Technology Pty Ltd ABN: 41 085 128 525 RTO No: 20829 TEQSA ID: PRV14007 CRICOS Provider Code: 02044E S1, 2019 ITAP3011 Page 3 of 3 a) You should design screens using standards across all four screens b) Your screen should use appropriate windows controls c) Your screen should have buttons for functions that can be performed by the screen. The d) button clicks would typically involve some business function/validation and data access. 4. Using the EDM, LINQ or Lambda, implement the data access functions representing the various button clicks. Project Organisation: The following is the suggested project organisation to implement the assignment. 1) Design of Database and screenshots 2) Creation of Database and screenshots 3) Once the above is done, you continue to develop the assignment, screenshot What to submit: A) Combine 1, 2 and 3 of the above (screenshots only) in a word document B) Zipped Project folder of 3 above.