65513 – Student ID:Full Name:ITAP3010Developing Data Access SolutionsProjectWeightage:

SOLUTION AT Australian Expert Writers

Student ID:Full Name:ITAP3010Developing Data Access SolutionsProjectWeightage: 25%Late penalty applies on late submission, 10% per day will be deducted.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 DOCUMENT file on LMS. You are most welcome to check your file with your lab tutor before your submission. No excuses 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.ITAP3010 Developing Data Access Solutions ProjectThe purpose of assignment is to assess students on the following Learning Outcomes:LO 1 Describe advanced features and concepts of database design and data access solution developmentLO 2 Model data using standard framework and use advanced queries across different data typesLO 3 Identify and implement data services and data access techniques over the webLO 4 Perform data synchronisations and manage transactionsLO 5 Deploy and monitor data access applications to help increase reliabilityMarking guide:Note: This Marking Scheme is used as a guide only to the final grade, and rubric will be created upon.Task Level of Performance0 1 2 3 4 5Created database with the mentioned tables.ER diagram.Constraint justification.Insert screenshots of each step in a Word document with proper essay format (i.e., TOC).Fully VS working project.A button to retrieve information.A button to exit.Fully working insert/edit/delete form.Total: /25 marksREAD THE FOLLOWING GUIDELINES CAREFULLY AND UNDERSTAND ALL REQUIREMENTS BEFORE STARTING THIS PROJECTProject SubmissionYour submission will contain a zip folder which should include:1) A word document (PDF will not be accepted) outlining the steps you used to create your VS project as well as the outputs by taking screenshots.2) Your full MS Visual Studio project folder.Put (1) and (2) together in one zipped file called ID_FullName.Please be clear that the unit coordinator will not be responsible for a student who is unable to submit successfully working copies of files in their submission. The student will have no further chance to submit files or receive any remarking if this is the case. Make sure you have fully tested your application before zipping and submitting. Your submission will be unzipped and placed into the marker’s folder directory for marking, so keep this in mind.If there is any exceptional case where a student’s project is unable to be marked, which should not occur, the project will be marked out 10 and the student will receive this mark out 10 as the final mark.You will submit the zipped file at the “Project folder on Moodle”. This form is shown to you when you click on “Project” from the Assessment area. The form page contains the terms and conditions of the project such as declaring that you have not plagiarised, have kept a copy of your work, etc. In uploading and submitting your zip file, you are agreeing to these terms and conditions, which you are being bound by in submitting work for the project and receiving a mark for it.Note:Relevant software can be downloaded here.Developing Data Access Solutions AssignmentThis assignment is on Database Development using Microsoft SQL Database (MSD), Microsoft SQL Server Management Studio (MSSMS) and Microsoft Visual Studio (VS). It involves the following features of (MSD), (MSSMS) and (VS) to be used in solving a business problem:A. Create database.B. Data entry: tables, fields, records, and primary key.C. Add, change, delete in database using forms.D. Create relationship, sort and retrieve data.E. Create and modify query, form, and report: wizard – Print report-based request (can be displayed in a text field or a text file).You are to develop a simple database that will store notebook specification including price for each notebook using MSMS. Follow the instructions below.1. MSMS.2. Create a blank database in the MSMS and name it studentID_CompShop.3. Create a new table named Laptop that contains these fields/attributes:Field name Data type ConstraintsID autonumber Justify your solution here:brand text Justify your solution here:model text Justify your solution here:processor text Justify your solution here:memory text Justify your solution here:harddisk text Justify your solution here:price currency Justify your solution here:4. Retain primary key fields name as Id.5. Enter these data into Laptop table:Field Name Databrand Dellmodel Insprion 6650processor intel; Core i7memory 16GBHarddisk 512GB SSDprice 899.006. Close Laptop table.7. Create a form to insert new data into Laptop table.8. Save the insert form as New Laptop Form.9. Enter data for four laptops using New Notebook Form.10. Implement a button to retrieve these items: Brand, Model, Price. Display them using a table or grid view.11. Create a report that will show all fields/attributes and sort the records according to Brand.12. Adjust the columns in report design to ensure all data are displayed in a proper manner.13. Close the report using a button.

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER

Assignment status: Already Solved By Our Experts

(USA, AUS, UK & CA Ph. D. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS

Order from Australian Expert Writers
Best Australian Academic Writers

QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER

YOU MAY ALSO READ ...  4 page research paper on felonies