{"id":111856,"date":"2022-06-29T00:00:00","date_gmt":"2022-06-29T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/06\/29\/cldv6211-assessment\/"},"modified":"2022-06-29T00:00:00","modified_gmt":"2022-06-29T00:00:00","slug":"cldv6211-assessment","status":"publish","type":"post","link":"https:\/\/www.studyproessays.com\/help\/cldv6211-assessment\/","title":{"rendered":"CLDV6211 ASSESSMENT"},"content":{"rendered":"<p>CLDV6211<br \/>\nASSESSMENT TYPE: POE (PAPER &amp; MARKING RUBRICS)<br \/>\nTOTAL MARK ALLOCATION: 180 MARKS<br \/>\nTOTAL HOURS: A minimum of 45 HOURS is suggested to complete this assessment<br \/>\nBy submitting this assignment, you acknowledge that you have read and understood all the rules as per the terms in the registration contract, in particular the assignment and assessment rules in The IIE Assessment Strategy and Policy (IIE009), the intellectual integrity and plagiarism rules in the Intellectual Integrity Policy (IIE023), as well as any rules and regulations published in the student portal.<br \/>\nINSTRUCTIONS:<br \/>\n1. No material may be copied from original sources, even if referenced correctly, unless it is a direct quote indicated with quotation marks. No more than 10% of the assignment may consist of direct quotes.<br \/>\n2. Make a copy of your assignment before handing it in.<br \/>\n3. All parts of the POE must be typed unless otherwise specified.<br \/>\n4. This is an individual POE. All work must be your own work.<br \/>\n5. Begin each section on a new page.<br \/>\n6. Follow all instructions on the PoE cover sheet.<br \/>\nReferencing Rubric<br \/>\nProviding evidence based on valid and referenced academic sources is a fundamental educational principle and the cornerstone of highquality academic work. Hence, The IIE considers it essential to develop the referencing skills of our students in our commitment to achieve high academic standards. Part of achieving these high standards is referencing in a way that is consistent, technically correct and congruent. This is not plagiarism, which is handled differently.<br \/>\nPoor quality formatting in your referencing will result in a penalty of a maximum of ten percent being deducted from the percentage awarded, according to the following guidelines. Please note, however, that evidence of plagiarism in the form of copied or uncited work (not referenced), absent reference lists, or exceptionally poor referencing, may result in action being taken in accordance with The IIE\u2019s Intellectual Integrity Policy (0023).<br \/>\nMarkers are required to provide feedback to students by indicating (circling\/underlining) the information that best describes the student\u2019s work.<br \/>\nMinor technical referencing errors: 5% deduction from the overall percentage \u2013 the student\u2019s work contains five or more errors listed in the minor errors\u2019 column in the table below.<br \/>\nMajor technical referencing errors: 10% deduction from the overall percentage \u2013 the student\u2019s work contains five or more errors listed in the major errors\u2019 column in the table below.<br \/>\nIf both minor and major errors are indicated, then 10% only (and not 5% or 15%) is deducted from the overall percentage. The examples provided below are not exhaustive but are provided to illustrate the error<br \/>\nRequired:<br \/>\nTechnically correct referencing style Minor errors in technical correctness of referencing style<br \/>\nDeduct 5% from percentage awarded Major errors in technical correctness of referencing style<br \/>\nDeduct 10% from percentage awarded<br \/>\nConsistency<br \/>\n\u2022 The same referencing format has been used for all in-text references and in the bibliography\/reference list. Minor inconsistencies.<br \/>\n\u2022 The referencing style is generally consistent, but there are one or two changes in the format of in-text referencing and\/or in the bibliography.<br \/>\n\u2022 For example, page numbers for direct quotes (in-text) have been provided for one source, but not in another instance. Two book chapters (bibliography) have been referenced in the bibliography in two different formats. Major inconsistencies.<br \/>\n\u2022 Poor and inconsistent referencing style used intext and\/or in the bibliography\/ reference list.<br \/>\n\u2022 Multiple formats for the same type of referencing have been used.<br \/>\n\u2022 For example, the format for direct quotes (in-text) and\/or book chapters (bibliography\/ reference list) is different across multiple instances.<br \/>\nTechnical correctness<br \/>\nReferencing format is technically correct throughout the submission.<br \/>\nPosition of the reference: a reference is directly associated with every concept or idea.<br \/>\nFor example, quotation marks, page numbers, years, etc. are applied correctly, sources in the bibliography\/reference list are correctly presented.<br \/>\nGenerally, technically correct with some minor errors.<br \/>\n\u2022 The correct referencing format has been consistently used, but there are one or two errors.<br \/>\n\u2022 Concepts and ideas are typically referenced, but a reference is missing from one small section of the work.<br \/>\n\u2022 Position of the references: references are only given at the beginning or end of every paragraph.<br \/>\n\u2022 For example, the student has incorrectly presented direct quotes (in-text) and\/or book chapters (bibliography\/reference list).<br \/>\nTechnically incorrect.<br \/>\n\u2022 The referencing format is incorrect.<br \/>\n\u2022 Concepts and ideas are typically referenced, but a reference is missing from small sections of the work.<br \/>\n\u2022 Position of the references: references are only given at the beginning or end of large sections of work.<br \/>\n\u2022 For example, incorrect author information is provided, no year of publication is provided, quotation marks and\/or page numbers for direct quotes missing, page numbers are provided for paraphrased material, the incorrect punctuation is used (in-text); the bibliography\/reference list is not in alphabetical order, the incorrect format for a book chapter\/journal article is used, information is missing e.g. no place of publication had been provided (bibliography); repeated sources on the reference list.<br \/>\nCongruence between in-text referencing and bibliography\/<br \/>\nreference list<br \/>\n\u2022 All sources are accurately reflected and are all accurately included in the bibliography\/ reference list.<br \/>\nGenerally, congruence between the intext referencing and the bibliography\/ reference list with one or two errors.<br \/>\n\u2022 There is largely a match between the sources presented in-text and the bibliography.<br \/>\n\u2022 For example, a source appears in the text, but not in the bibliography\/ reference list or vice versa. A lack of congruence between the in-text referencing and the bibliography.<br \/>\n\u2022 No relationship\/several incongruencies between the in-text referencing and the bibliography\/reference list.<br \/>\n\u2022 For example, sources are included in-text, but not in the bibliography and vice versa, a link, rather than the actual reference is provided in the bibliography.<br \/>\nIn summary: the recording of references is accurate and complete. In summary, at least 80% of the sources are correctly reflected and included in a reference list. In summary, at least 60% of the sources are incorrectly reflected and\/or not included in reference list.<br \/>\nOverall Feedback about the consistency, technical correctness and congruence between in-text referencing and bibliography:<br \/>\n&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;. &#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;&#8230;.<br \/>\nPortfolio of Evidence (PoE) \u2014 Background<br \/>\nWith the growing popularity of e-hailing there is a growing need for people who want to be able to access convenient, affordable, and safe transport to and from wherever they may want to go. Being a part of the driver community for an environment such as this is not always the easiest thing as the drivers of these e-hailing vehicles are normally the owners of the cars, meaning their car is for both work and leisure, which can take a huge toll on the car itself.<br \/>\nBecause the maintenance of the car is also normally solely dependent on the owner unless they have a motor plan or service plan, working everyday with their cars means this service period comes quick and fast and the renewal of these plans can prove to be a little costly, which sometimes makes it a whole lot harder to maintain a solid career as an e-hailing driver.<br \/>\n\u201cThe Ride You Rent\u201d is a new start-up that hopes to solve that issue by providing drivers with the ability to rent out a car for a specified amount of time to perform their regular e-hailing duties and once done they can return the vehicle and not have to worry about the maintenance. At present they have been capturing cars and tracking rentals using a paper-based flat-file system, which can become very hard to manage on a day-to-day basis.<br \/>\nThe Ride You Rent has sent out an RFQ to contractors who can develop a management system where they can manage drivers, rentals and returns on all their rental vehicles, as well as track any late fees that could be incurred should a driver return a car after the specified rental time.<br \/>\nThey would like to be able to access this system from a desktop computer as well as a mobile phone, as some of the Inspectors are normally sent out to collect the vehicles at pick-up points, if the drivers are not able to return them straight to the depot. In the spirit of moving to a paperless system they want the Inspectors to be able to log the return using a mobile phone as soon as the vehicle is collected.<br \/>\nThey do plan on expanding the system to add more functionality but for now they only need the<br \/>\nDriver, Inspector, Vehicle, Rental, and Return Management functionality designed and developed.<br \/>\nBelow are some samples of the hard copy records currently kept by The Ride You Rent:<br \/>\nCar Make<br \/>\ndescription<br \/>\nHyundai<br \/>\nBMW<br \/>\nMercedes Benz<br \/>\nToyota<br \/>\nFord<br \/>\nCarBodyType<br \/>\ndescription<br \/>\nHatchback<br \/>\nSedan<br \/>\nCoupe<br \/>\nSUV<br \/>\nCar<br \/>\nCarNo Car Make Model Body Type Kilometres<br \/>\nTravelled Service<br \/>\nKilometres Available<br \/>\nHYU001 Hyundai Grand i10<br \/>\n1.0 Motion Hatchback 1500 15000 yes<br \/>\nHYU002 Hyundai i20 1.2 Fluid Hatchback 3000 15000 yes<br \/>\nBMW001 BMW 320d 1.2 Sedan 20000 50000 yes<br \/>\nBMW002 BMW 240d 1.4 Sedan 9500 15000 yes<br \/>\nTOY001 Toyota Corolla 1.0 Sedan 15000 50000 yes<br \/>\nTOY002 Toyota Avanza 1.0 SUV 98000 15000 yes<br \/>\nTOY003 Toyota Corolla<br \/>\nQuest 1.0 Sedan 15000 50000 yes<br \/>\nMER001 Mercedes<br \/>\nBenz c180 Sedan 5200 15000 yes<br \/>\nMER002 Mercedes<br \/>\nBenz A200 Sedan Sedan 4080 15000 yes<br \/>\nFOR001 Ford Fiesta 1.0 Sedan 7600 15000 yes<br \/>\nInspector<br \/>\nInspector_no Name Email Mobile<br \/>\nI101 Bud Barnes bud@therideyourent.com 0821585359<br \/>\nI102 Tracy Reeves tracy@therideyourent.com 0822889988<br \/>\nI103 Sandra Goodwin sandra@therideyourent.com 0837695468<br \/>\nI104 Shannon Burke shannon@therideyourent.com 0836802514<br \/>\nDriver<br \/>\nName Address Email Mobile<br \/>\nGabrielle<br \/>\nClarke 917 Heuvel St Botshabelo<br \/>\nFree State 9781 gorix10987@macauvpn.com 0837113269<br \/>\nGeoffrey<br \/>\nFranklin 1114 Dorp St Paarl Western<br \/>\nCape 7655 noceti8743@drlatvia.com 0847728052<br \/>\nFawn Cooke 2158 Prospect St<br \/>\nGarsfontein Gauteng 0042 yegifav388@enamelme.com 0821966584<br \/>\nDarlene<br \/>\nPeters 2529 St. John Street<br \/>\nSomerset West Western<br \/>\nCape 7110 mayeka4267@macauvpn.com 0841221244<br \/>\nVita Soto 1474 Wolmarans St Sundra<br \/>\nMpumalanga 2200 wegog55107@drlatvia.com 0824567924<br \/>\nOpal Rehbein 697 Thutlwa St Letaba<br \/>\nLimpopo 0870 yiyow34505@enpaypal.com 0826864938<br \/>\nVernon<br \/>\nHodgson 1935 Thutlwa St Letsitele<br \/>\nLimpopo 0885 gifeh11935@enamelme.com 0855991446<br \/>\nCrispin<br \/>\nWheatly 330 Sandown Rd Cape<br \/>\nTown Western Cape 8018 likon78255@macauvpn.com 0838347945<br \/>\nMelanie<br \/>\nCunningham 616 Loop St Atlantis<br \/>\nWestern Cape 7350 sehapeb835@macauvpn.com 0827329001<br \/>\nKevin Peay 814 Daffodil Dr Elliotdale<br \/>\nEastern Cape 5118 xajic53991@enpaypal.com 0832077149<br \/>\nRental<br \/>\nCarno Inspector Driver Rental Fee Start Date End Date<br \/>\nHYU001 Bud Barnes Gabrielle Clarke 5000 2021-08-30 2021-08-31<br \/>\nHYU002 Bud Barnes Gabrielle Clarke 5000 2021-09-01 2021-09-10<br \/>\nFOR001 Bud Barnes Geoffrey Franklin 6500 2021-09-01 2021-09-10<br \/>\nBMW002 Tracy Reeves Vita Soto 7000 2021-09-20 2021-09-25<br \/>\nTOY002 Tracy Reeves Darlene Peters 5000 2021-10-03 2021-10-31<br \/>\nMER001 Sandra Goodwin Darlene Peters 8000 2021-10-05 2021-10-15<br \/>\nHYU002 Shannon Burke Vernon Hodgson 5000 2021-12-01 2022-02-10<br \/>\nTOY003 Shannon Burke Melanie<br \/>\nCunningham 5000 2021-08-10 2021-08-31<br \/>\nReturn<br \/>\nCarno Inspector Driver Return Date Elapsed<br \/>\nDate Fine<br \/>\nHYU001 Bud Barnes Gabrielle Clarke 2021-08-31 0 0<br \/>\nHYU002 Bud Barnes Gabrielle Clarke 2021-09-10 0 0<br \/>\nFOR001 Bud Barnes Geoffrey Franklin 2021-09-10 0 0<br \/>\nBMW002 Tracy Reeves Vita Soto 2021-09-30 5 2500<br \/>\nTOY002 Tracy Reeves Darlene Peters 2021-10-31 2 1000<br \/>\nMER001 Sandra Goodwin Darlene Peters 2021-10-15 1 500<br \/>\nHYU002 Shannon Burke Vernon Hodgson 2022-02-10 0 0<br \/>\nTOY003 Shannon Burke Melanie<br \/>\nCunningham 2021-08-31 0 0<br \/>\nReedsy.com. 2021. English Character name Generator. [Online]. Available at:<br \/>\nhttps:\/\/blog.reedsy.com\/character-name-generator\/language\/english\/ [Accessed 28 August 2021].<br \/>\nFakeaddressgenerator.com. South Africa Address Generator. [Online]. Available at:<br \/>\nhttps:\/\/www.fakeaddressgenerator.com\/World_more\/South_Africa_address_generator [Accessed 28 August 2021].<br \/>\nTemp-mail.org. Your Temporary Email Address. [Online]. Available at: https:\/\/temp-mail.org\/en\/ [Accessed 28 August 2021].<br \/>\nInstructions<br \/>\nThe Portfolio of Evidence (PoE) requires you to create a database cloud web application for The<br \/>\nRide You Rent. The web application will be progressively developed through the execution of Part 1 (database design) and Part 2 (data, queries and migration) that build on each other to create a final application (POE Part 3) for CLDV6211<br \/>\nSummary Sheet:<br \/>\nITEM DESCRIPTION<br \/>\nSummary of Activities Students must upload their submission to Learn or any other secure alternative platform as instructed by the lecturer. Please verify where and how this should be done with the lecturer before submission.<br \/>\nPlease supply the URL of the Web App with your submission, and include file exports as indicated for the Azure database.<br \/>\nTools &amp; Resources \u2022 Microsoft Visual Studio 2017 or higher<br \/>\n\u2022 Microsoft Visio or other database design software;<br \/>\n\u2022 MS SQL Server 2012 or higher<br \/>\n\u2022 Windows Azure subscription with Microsoft Azure SQL Database<br \/>\nThe data for The Ride You Rent as shown above is not necessarily normalised \u2013 it is your duty to organise the data in the most optimal way possible. For example, the hard copy records shown above will not necessarily map directly to database tables. You are expected to use these tables as a starting point for your own normalisation and optimisation of The Ride You Rent.<br \/>\nWhere required you should show all SQL scripts along with their results.<br \/>\nSubmit the URL of your Web App.<br \/>\nSubmit a file export of your Azure database.<br \/>\nPOE Part 1 \u2014 Database Design (Marks: 50)<br \/>\nLearning Units: 1 \u2013 3<br \/>\nAt the end of this specific task, students should be able to:<br \/>\n\u2022 Create a normalized entity relationship model using the IDEF1X modelling notation<br \/>\n\u2022 Understand the relationships between entities, along with their multiplicities (cardinality and<br \/>\nparticipation)<br \/>\n\u2022 Detail all the relevant names for your attributes and keys to fit the scenario<br \/>\nProduce a normalised entity-relationship model for the proposed database system for The Ride You Rent. Use Integration Definition for Information Modelling (IDEF1X) standard, and normalise up to third normal form (3NF)<br \/>\nMARK ALLOCATION<br \/>\nDescription Marks<br \/>\nNotation: Diagram uses an appropriate E-R notation. The notation is used correctly for all elements of the diagram. 5<br \/>\nEntity sets: Diagram captures all entity sets including look-up tables necessary for a database that would satisfy the initial problem statement. 10<br \/>\nAttributes and Keys: Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial problem statement. 10<br \/>\nComplexity: The required number of tables and foreign key relationships will be needed to implement the database. 10<br \/>\nConstraints: Diagram captures all cardinality and participation constraints necessary for a database that would satisfy the initial problem statement. (Recognising that if all relationships are legitimately many-many with partial participation, then no constraint annotations are necessary.) 10<br \/>\nProfessionalism: Diagram presents a professional appearance. It could be shared with a \u201creal-world\u201d customer without changes. 5<br \/>\nRUBRIC FOR POE PART 1<br \/>\nRUBRIC 1 (for POE Part 1) Levels of Achievement<br \/>\nIn order to be awarded full marks for these elements, students need to have: Excellent Good Developing Poor<br \/>\nScore Ranges Per Level<br \/>\nNotation: Diagram uses an appropriate E-R notation. The notation is used correctly for all elements of the diagram. 4 &#8211; 5 3 &#8211; 4 2 &#8211; 3 0 &#8211; 2<br \/>\nEntity sets: Diagram captures all entity sets including look-up tables necessary for a database that would satisfy the initial problem statement. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 5 0 &#8211; 2<br \/>\nAttributes and Keys: Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial problem statement. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 5 0 &#8211; 2<br \/>\nComplexity: The required number of tables and foreign key relationships will be needed to implement the database. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 5 0 &#8211; 2<br \/>\nConstraints: Diagram captures all cardinality and participation constraints necessary for a database that would satisfy the initial problem statement. (Recognising that if all relationships are legitimately many-many with partial participation, then no constraint annotations are necessary.) 9 &#8211; 10 7 &#8211; 8 3 &#8211; 5 0 &#8211; 2<br \/>\nProfessionalism: Diagram presents a professional appearance. It could be shared with a \u201creal-world\u201d customer without changes. 4 &#8211; 5 3 &#8211; 4 2 &#8211; 3 0 &#8211; 2<br \/>\nPOE PART 1 SUBTOTAL \/50<br \/>\nPOE Part 2 \u2014 Data, Queries and Migration (Marks: 60)<br \/>\nLearning Units: 4 \u2013 6<br \/>\nAt the end of this specific task, students should be able to:<br \/>\n\u2022 Use SQL statements to create and change databases, tables, and indices<br \/>\n\u2022 Use the INSERT, UPDATE and DELETE statements to modify the data in a table<br \/>\n\u2022 Construct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER BY clause<br \/>\n\u2022 Demonstrate an understanding of database migration a local instance to an Azure SQL database<br \/>\nA. Complete the following task by working on a local MS SQL Server.<br \/>\nFor each task in this section you need to submit copies of all your SQL scripts as well as the results of the scripts (e.g. the Question Assignment results or the finished tables.)<br \/>\n1. Create all the main tables using SQL. (Remember to show all your SQL scripts and the<br \/>\nfinished tables as stated in the instructions).<br \/>\n2. Create all the lookup tables using SQL.<br \/>\n3. Populate data on all the relevant tables (Car, Inspector, Driver, Rental, Return).<br \/>\n4. Populate data on all the relevant tables (Car, Inspector, Driver, Rental, Return).<br \/>\n5. Write a Question Assignment that will return all the rentals placed between the following dates \u201c2021-0801\u201d AND \u201c2021-10-30\u201d.<br \/>\n6. Write a Question Assignment that selects all the rentals placed by Bud Barnes.<br \/>\n7. Write a Question Assignment that displays all the returns for the car make Toyota.<br \/>\n8. Write a Question Assignment that counts the number of rentals that were placed for the car make Hyundai.<br \/>\n9. Write a Question Assignment to update the Model of the car with the CarNo FOR001 from \u201cFiesta\u201d to \u201cFocus\u201d.<br \/>\n10. Write a Question Assignment that will display the CarNo, Driver Name, Rental Fee, Start Date, End Date<br \/>\nand Availability of all available rentals.<br \/>\n11. Write a Question Assignment that will show a list of the available car makes in the database use the DISTINCT command.<br \/>\n12. Write a Question Assignment that will determine the cars which will need service soon. If a car\u2019s kilometres<br \/>\ntravelled is 9000 kilometres away from the service kilometres that would indicate that the car would need to get a service soon.<br \/>\n13. Write a Question Assignment that will calculate the late fee for a return (a R500 a day fine is placed on<br \/>\nrentals returned passed the elapsed return date. The Question Assignment should use the return date and the current\/Today\u2019s date to calculate the elapsed number of days and multiply those days by the R500 fine to get the total fine).<br \/>\nB. Migrate the database that you have created above to Windows Azure Online Platform.<br \/>\nFor this section you need to submit the following evidence:<br \/>\n\u2022 A BACPAC file exported from SSMS using the Export Data-Tier Application wizard.<br \/>\n\u2022 Take a screenshot of the connection to your MS Azure SQL Server (shown in your local SSMS) with at least one table result called back as a Question Assignment.<br \/>\n\u2022 Take a second screenshot from the Azure Question Assignment Editor to demonstrate that data shows up<br \/>\nin the Question Assignment editor on Microsoft Azure (do this for the same table used for the first screenshot).<br \/>\nMARK ALLOCATION<br \/>\nDescription Marks<br \/>\nUse SQL statements to create and change databases, tables and indices. 15<br \/>\nUse the INSERT, UPDATE and DELETE statements to modify the data in a table. 15<br \/>\nConstruct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER by clause. 15<br \/>\nDemonstrate proper coding format for SQL statements. 5<br \/>\nDatabase Migration to Windows Azure. 10<br \/>\nRUBRIC FOR POE PART 2<br \/>\nRUBRIC 2 (for POE Part 2) Levels of Achievement<br \/>\nIn order to be awarded full marks for these elements, students need to have: Excellent Good Developing Poor<br \/>\nScore Ranges Per Level<br \/>\nUse SQL statements to create and change databases, tables and indices. 12 &#8211; 15 9 &#8211; 11 4 &#8211; 8 0 &#8211; 3<br \/>\nUse the INSERT, UPDATE and DELETE statements to modify the data in a table. 12 &#8211; 15 9 &#8211; 11 4 &#8211; 8 0 &#8211; 3<br \/>\nConstruct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER BY clause. 12 &#8211; 15 9 &#8211; 11 4 &#8211; 8 0 &#8211; 3<br \/>\nDemonstrate proper coding format for SQL statements. 4 &#8211; 5 3 &#8211; 4 2 &#8211; 3 0 &#8211; 2<br \/>\nDatabase Migration to Windows Azure. 9 &#8211; 10 6 &#8211; 8 3 &#8211; 5 0 &#8211; 2<br \/>\nPOE PART 2 SUBTOTAL \/60<br \/>\nPOE Part 3 \u2014 Web Application (Marks:70)<br \/>\nLearning Unit: 8<br \/>\nAt the end of this specific task, students should be able to:<br \/>\n\u2022 Demonstrate the ability to implement required CRUD and management functionality within a C# web application<br \/>\n\u2022 Deploy a web app on Azure platform and make it accessible on the web<br \/>\nUsing information from Task 1 and 2, develop and deploy on cloud (Azure platform) a C# web application that will serve as an interface for The Ride You Rent.<br \/>\nYour web application should be able to:<br \/>\n\u2022 Create, read, update and delete Cars, Inspectors, and Drivers.<br \/>\n\u2022 Create and retrieve new Rentals.<br \/>\n\u2022 Create and retrieve Returns.<br \/>\n\u2022 Only allow registered Inspectors to access the system.<br \/>\n\u2022 Calculate the penalty fee on a rental that was returned late.<br \/>\n\u2022 Deploy Web App on Azure Platform and is accessible on the Web.<br \/>\nMARK ALLOCATION<br \/>\nDescription Marks<br \/>\nA final version of your Web App with:<br \/>\nGood coding standards: Efficient code (no redundancy). 5<br \/>\nUser interface: Appropriate controls employed to support web functionality. 5<br \/>\nApplication functionality: Create, Read, update and Delete Cars, Inspectors, and Drivers. 10<br \/>\nApplication functionality: Create and Retrieve new Rentals. 10<br \/>\nApplication functionality: Create and Retrieve Returns 10<br \/>\nApplication functionality: Only allow registered Inspectors to access the system. 10<br \/>\nApplication functionality: Calculate the penalty fee on a rental that was returned late 10<br \/>\nApplication functionality: Deploy Web App on Azure Platform and is accessible on the Web. 10<br \/>\nDETAILED RUBRIC FOR POE PART 3<br \/>\nRUBRIC 3 (POE Part 3) Levels of Achievement<br \/>\nIn order to be awarded full marks for these elements of the POE, students need to have: Excellent Good Developing Poor<br \/>\nScore Ranges Per Level<br \/>\nGood coding standards: Efficient code (no redundancy). 4 &#8211; 5 3 &#8211; 4 2 &#8211; 3 0 &#8211; 2<br \/>\nUser interface: Appropriate controls employed to support web functionality. 4 &#8211; 5 3 &#8211; 4 2 &#8211; 3 0 &#8211; 2<br \/>\nApplication functionality: Create, Read, update and Delete Cars, Inspectors, and Drivers. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 6 0 &#8211; 2<br \/>\nApplication functionality: Create and Retrieve new Rentals. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 6 0 &#8211; 2<br \/>\nApplication functionality: Create and Retrieve<br \/>\nReturns 9 &#8211; 10 7 &#8211; 8 3 &#8211; 6 0 &#8211; 2<br \/>\nApplication functionality: Only allow registered Inspectors to access the system. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 6 0 &#8211; 2<br \/>\nApplication functionality: Calculate the penalty fee on a rental that was returned late 9 &#8211; 10 7 &#8211; 8 3 &#8211; 6 0 &#8211; 2<br \/>\nApplication functionality: Deploy Web App on Azure Platform and is accessible on the Web. 9 &#8211; 10 7 &#8211; 8 3 &#8211; 6 0 &#8211; 2<br \/>\nPOE PART 3 SUBTOTAL \/70<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CLDV6211 ASSESSMENT TYPE: POE (PAPER &amp; MARKING RUBRICS) TOTAL MARK ALLOCATION: 180 MARKS TOTAL HOURS: A minimum of 45 HOURS is suggested to complete this\u2026<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7316,7318,7317,7315,7319,7321],"tags":[642,618,8825,576,116,631,19,643,473,633,630,628,450,597,594,626,635,574,622,624,620,621,619,623,617,625,627,634,629,632,644,645,42,66],"class_list":["post-111856","post","type-post","status-publish","format-standard","hentry","category-best-dissertation-writers-uk","category-british-dissertation-writers","category-dissertation-help-online","category-dissertation-writing-services-uk","category-help-with-dissertation-writing","category-uk-dissertation-help","tag-apps-that-write-essays-for-you-free","tag-assignment-writing-services-in-usa","tag-bes","tag-best-dissertation-writing-services","tag-best-essay-writing-service","tag-best-paper-writing-services","tag-best-research-paper-writing-services-in-usa","tag-best-website-to-write-my-essay","tag-cheap-essay-writing-service","tag-cheap-research-paper-writing-service","tag-college-paper-writing-service","tag-dissertation-help-online","tag-dissertation-writing-services","tag-dissertation-writing-services-illegal","tag-dissertation-writing-services-near-me","tag-dissertation-writing-services-usa","tag-essay-writing-service","tag-free-dissertation-writing-services","tag-homework-essay-writer","tag-homework-essay-writer-free","tag-homework-help-global","tag-homework-help-services","tag-homework-help-usa","tag-homework-writing-help","tag-homework-writing-service","tag-legit-research-paper-writing-services","tag-legitimate-dissertation-writing-services","tag-research-paper-writer-online-free","tag-research-paper-writing-services-online","tag-research-paper-writing-websites","tag-write-my-essay-for-me-cheap","tag-write-my-essay-for-me-tik-tok","tag-write-my-essay-free","tag-write-my-paper"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/111856","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=111856"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/111856\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=111856"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=111856"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=111856"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}