CLDV6211
ASSESSMENT TYPE: POE (PAPER & MARKING RUBRICS)
TOTAL MARK ALLOCATION: 180 MARKS
TOTAL HOURS: A minimum of 45 HOURS is suggested to complete this assessment
By 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.
INSTRUCTIONS:
1. 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.
2. Make a copy of your assignment before handing it in.
3. All parts of the POE must be typed unless otherwise specified.
4. This is an individual POE. All work must be your own work.
5. Begin each section on a new page.
6. Follow all instructions on the PoE cover sheet.
Referencing Rubric
Providing 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.
Poor 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’s Intellectual Integrity Policy (0023).
Markers are required to provide feedback to students by indicating (circling/underlining) the information that best describes the student’s work.
Minor technical referencing errors: 5% deduction from the overall percentage – the student’s work contains five or more errors listed in the minor errors’ column in the table below.
Major technical referencing errors: 10% deduction from the overall percentage – the student’s work contains five or more errors listed in the major errors’ column in the table below.
If 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
Required:
Technically correct referencing style Minor errors in technical correctness of referencing style
Deduct 5% from percentage awarded Major errors in technical correctness of referencing style
Deduct 10% from percentage awarded
Consistency
• The same referencing format has been used for all in-text references and in the bibliography/reference list. Minor inconsistencies.
• 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.
• 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.
• Poor and inconsistent referencing style used intext and/or in the bibliography/ reference list.
• Multiple formats for the same type of referencing have been used.
• For example, the format for direct quotes (in-text) and/or book chapters (bibliography/ reference list) is different across multiple instances.
Technical correctness
Referencing format is technically correct throughout the submission.
Position of the reference: a reference is directly associated with every concept or idea.
For example, quotation marks, page numbers, years, etc. are applied correctly, sources in the bibliography/reference list are correctly presented.
Generally, technically correct with some minor errors.
• The correct referencing format has been consistently used, but there are one or two errors.
• Concepts and ideas are typically referenced, but a reference is missing from one small section of the work.
• Position of the references: references are only given at the beginning or end of every paragraph.
• For example, the student has incorrectly presented direct quotes (in-text) and/or book chapters (bibliography/reference list).
Technically incorrect.
• The referencing format is incorrect.
• Concepts and ideas are typically referenced, but a reference is missing from small sections of the work.
• Position of the references: references are only given at the beginning or end of large sections of work.
• 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.
Congruence between in-text referencing and bibliography/
reference list
• All sources are accurately reflected and are all accurately included in the bibliography/ reference list.
Generally, congruence between the intext referencing and the bibliography/ reference list with one or two errors.
• There is largely a match between the sources presented in-text and the bibliography.
• 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.
• No relationship/several incongruencies between the in-text referencing and the bibliography/reference list.
• 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.
In 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.
Overall Feedback about the consistency, technical correctness and congruence between in-text referencing and bibliography:
………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….
Portfolio of Evidence (PoE) — Background
With 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.
Because 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.
“The Ride You Rent” 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.
The 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.
They 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.
They do plan on expanding the system to add more functionality but for now they only need the
Driver, Inspector, Vehicle, Rental, and Return Management functionality designed and developed.
Below are some samples of the hard copy records currently kept by The Ride You Rent:
Car Make
description
Hyundai
BMW
Mercedes Benz
Toyota
Ford
CarBodyType
description
Hatchback
Sedan
Coupe
SUV
Car
CarNo Car Make Model Body Type Kilometres
Travelled Service
Kilometres Available
HYU001 Hyundai Grand i10
1.0 Motion Hatchback 1500 15000 yes
HYU002 Hyundai i20 1.2 Fluid Hatchback 3000 15000 yes
BMW001 BMW 320d 1.2 Sedan 20000 50000 yes
BMW002 BMW 240d 1.4 Sedan 9500 15000 yes
TOY001 Toyota Corolla 1.0 Sedan 15000 50000 yes
TOY002 Toyota Avanza 1.0 SUV 98000 15000 yes
TOY003 Toyota Corolla
Quest 1.0 Sedan 15000 50000 yes
MER001 Mercedes
Benz c180 Sedan 5200 15000 yes
MER002 Mercedes
Benz A200 Sedan Sedan 4080 15000 yes
FOR001 Ford Fiesta 1.0 Sedan 7600 15000 yes
Inspector
Inspector_no Name Email Mobile
I101 Bud Barnes bud@therideyourent.com 0821585359
I102 Tracy Reeves tracy@therideyourent.com 0822889988
I103 Sandra Goodwin sandra@therideyourent.com 0837695468
I104 Shannon Burke shannon@therideyourent.com 0836802514
Driver
Name Address Email Mobile
Gabrielle
Clarke 917 Heuvel St Botshabelo
Free State 9781 gorix10987@macauvpn.com 0837113269
Geoffrey
Franklin 1114 Dorp St Paarl Western
Cape 7655 noceti8743@drlatvia.com 0847728052
Fawn Cooke 2158 Prospect St
Garsfontein Gauteng 0042 yegifav388@enamelme.com 0821966584
Darlene
Peters 2529 St. John Street
Somerset West Western
Cape 7110 mayeka4267@macauvpn.com 0841221244
Vita Soto 1474 Wolmarans St Sundra
Mpumalanga 2200 wegog55107@drlatvia.com 0824567924
Opal Rehbein 697 Thutlwa St Letaba
Limpopo 0870 yiyow34505@enpaypal.com 0826864938
Vernon
Hodgson 1935 Thutlwa St Letsitele
Limpopo 0885 gifeh11935@enamelme.com 0855991446
Crispin
Wheatly 330 Sandown Rd Cape
Town Western Cape 8018 likon78255@macauvpn.com 0838347945
Melanie
Cunningham 616 Loop St Atlantis
Western Cape 7350 sehapeb835@macauvpn.com 0827329001
Kevin Peay 814 Daffodil Dr Elliotdale
Eastern Cape 5118 xajic53991@enpaypal.com 0832077149
Rental
Carno Inspector Driver Rental Fee Start Date End Date
HYU001 Bud Barnes Gabrielle Clarke 5000 2021-08-30 2021-08-31
HYU002 Bud Barnes Gabrielle Clarke 5000 2021-09-01 2021-09-10
FOR001 Bud Barnes Geoffrey Franklin 6500 2021-09-01 2021-09-10
BMW002 Tracy Reeves Vita Soto 7000 2021-09-20 2021-09-25
TOY002 Tracy Reeves Darlene Peters 5000 2021-10-03 2021-10-31
MER001 Sandra Goodwin Darlene Peters 8000 2021-10-05 2021-10-15
HYU002 Shannon Burke Vernon Hodgson 5000 2021-12-01 2022-02-10
TOY003 Shannon Burke Melanie
Cunningham 5000 2021-08-10 2021-08-31
Return
Carno Inspector Driver Return Date Elapsed
Date Fine
HYU001 Bud Barnes Gabrielle Clarke 2021-08-31 0 0
HYU002 Bud Barnes Gabrielle Clarke 2021-09-10 0 0
FOR001 Bud Barnes Geoffrey Franklin 2021-09-10 0 0
BMW002 Tracy Reeves Vita Soto 2021-09-30 5 2500
TOY002 Tracy Reeves Darlene Peters 2021-10-31 2 1000
MER001 Sandra Goodwin Darlene Peters 2021-10-15 1 500
HYU002 Shannon Burke Vernon Hodgson 2022-02-10 0 0
TOY003 Shannon Burke Melanie
Cunningham 2021-08-31 0 0
Reedsy.com. 2021. English Character name Generator. [Online]. Available at:
https://blog.reedsy.com/character-name-generator/language/english/ [Accessed 28 August 2021].
Fakeaddressgenerator.com. South Africa Address Generator. [Online]. Available at:
https://www.fakeaddressgenerator.com/World_more/South_Africa_address_generator [Accessed 28 August 2021].
Temp-mail.org. Your Temporary Email Address. [Online]. Available at: https://temp-mail.org/en/ [Accessed 28 August 2021].
Instructions
The Portfolio of Evidence (PoE) requires you to create a database cloud web application for The
Ride 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
Summary Sheet:
ITEM DESCRIPTION
Summary 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.
Please supply the URL of the Web App with your submission, and include file exports as indicated for the Azure database.
Tools & Resources • Microsoft Visual Studio 2017 or higher
• Microsoft Visio or other database design software;
• MS SQL Server 2012 or higher
• Windows Azure subscription with Microsoft Azure SQL Database
The data for The Ride You Rent as shown above is not necessarily normalised – 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.
Where required you should show all SQL scripts along with their results.
Submit the URL of your Web App.
Submit a file export of your Azure database.
POE Part 1 — Database Design (Marks: 50)
Learning Units: 1 – 3
At the end of this specific task, students should be able to:
• Create a normalized entity relationship model using the IDEF1X modelling notation
• Understand the relationships between entities, along with their multiplicities (cardinality and
participation)
• Detail all the relevant names for your attributes and keys to fit the scenario
Produce 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)
MARK ALLOCATION
Description Marks
Notation: Diagram uses an appropriate E-R notation. The notation is used correctly for all elements of the diagram. 5
Entity sets: Diagram captures all entity sets including look-up tables necessary for a database that would satisfy the initial problem statement. 10
Attributes and Keys: Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial problem statement. 10
Complexity: The required number of tables and foreign key relationships will be needed to implement the database. 10
Constraints: 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
Professionalism: Diagram presents a professional appearance. It could be shared with a “real-world” customer without changes. 5
RUBRIC FOR POE PART 1
RUBRIC 1 (for POE Part 1) Levels of Achievement
In order to be awarded full marks for these elements, students need to have: Excellent Good Developing Poor
Score Ranges Per Level
Notation: Diagram uses an appropriate E-R notation. The notation is used correctly for all elements of the diagram. 4 – 5 3 – 4 2 – 3 0 – 2
Entity sets: Diagram captures all entity sets including look-up tables necessary for a database that would satisfy the initial problem statement. 9 – 10 7 – 8 3 – 5 0 – 2
Attributes and Keys: Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial problem statement. 9 – 10 7 – 8 3 – 5 0 – 2
Complexity: The required number of tables and foreign key relationships will be needed to implement the database. 9 – 10 7 – 8 3 – 5 0 – 2
Constraints: 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 – 10 7 – 8 3 – 5 0 – 2
Professionalism: Diagram presents a professional appearance. It could be shared with a “real-world” customer without changes. 4 – 5 3 – 4 2 – 3 0 – 2
POE PART 1 SUBTOTAL /50
POE Part 2 — Data, Queries and Migration (Marks: 60)
Learning Units: 4 – 6
At the end of this specific task, students should be able to:
• Use SQL statements to create and change databases, tables, and indices
• Use the INSERT, UPDATE and DELETE statements to modify the data in a table
• Construct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER BY clause
• Demonstrate an understanding of database migration a local instance to an Azure SQL database
A. Complete the following task by working on a local MS SQL Server.
For 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.)
1. Create all the main tables using SQL. (Remember to show all your SQL scripts and the
finished tables as stated in the instructions).
2. Create all the lookup tables using SQL.
3. Populate data on all the relevant tables (Car, Inspector, Driver, Rental, Return).
4. Populate data on all the relevant tables (Car, Inspector, Driver, Rental, Return).
5. Write a Question Assignment that will return all the rentals placed between the following dates “2021-0801” AND “2021-10-30”.
6. Write a Question Assignment that selects all the rentals placed by Bud Barnes.
7. Write a Question Assignment that displays all the returns for the car make Toyota.
8. Write a Question Assignment that counts the number of rentals that were placed for the car make Hyundai.
9. Write a Question Assignment to update the Model of the car with the CarNo FOR001 from “Fiesta” to “Focus”.
10. Write a Question Assignment that will display the CarNo, Driver Name, Rental Fee, Start Date, End Date
and Availability of all available rentals.
11. Write a Question Assignment that will show a list of the available car makes in the database use the DISTINCT command.
12. Write a Question Assignment that will determine the cars which will need service soon. If a car’s kilometres
travelled is 9000 kilometres away from the service kilometres that would indicate that the car would need to get a service soon.
13. Write a Question Assignment that will calculate the late fee for a return (a R500 a day fine is placed on
rentals returned passed the elapsed return date. The Question Assignment should use the return date and the current/Today’s date to calculate the elapsed number of days and multiply those days by the R500 fine to get the total fine).
B. Migrate the database that you have created above to Windows Azure Online Platform.
For this section you need to submit the following evidence:
• A BACPAC file exported from SSMS using the Export Data-Tier Application wizard.
• 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.
• Take a second screenshot from the Azure Question Assignment Editor to demonstrate that data shows up
in the Question Assignment editor on Microsoft Azure (do this for the same table used for the first screenshot).
MARK ALLOCATION
Description Marks
Use SQL statements to create and change databases, tables and indices. 15
Use the INSERT, UPDATE and DELETE statements to modify the data in a table. 15
Construct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER by clause. 15
Demonstrate proper coding format for SQL statements. 5
Database Migration to Windows Azure. 10
RUBRIC FOR POE PART 2
RUBRIC 2 (for POE Part 2) Levels of Achievement
In order to be awarded full marks for these elements, students need to have: Excellent Good Developing Poor
Score Ranges Per Level
Use SQL statements to create and change databases, tables and indices. 12 – 15 9 – 11 4 – 8 0 – 3
Use the INSERT, UPDATE and DELETE statements to modify the data in a table. 12 – 15 9 – 11 4 – 8 0 – 3
Construct SELECT statements to solve data requirements by coding the SELECT clause, the WHERE clause and the ORDER BY clause. 12 – 15 9 – 11 4 – 8 0 – 3
Demonstrate proper coding format for SQL statements. 4 – 5 3 – 4 2 – 3 0 – 2
Database Migration to Windows Azure. 9 – 10 6 – 8 3 – 5 0 – 2
POE PART 2 SUBTOTAL /60
POE Part 3 — Web Application (Marks:70)
Learning Unit: 8
At the end of this specific task, students should be able to:
• Demonstrate the ability to implement required CRUD and management functionality within a C# web application
• Deploy a web app on Azure platform and make it accessible on the web
Using 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.
Your web application should be able to:
• Create, read, update and delete Cars, Inspectors, and Drivers.
• Create and retrieve new Rentals.
• Create and retrieve Returns.
• Only allow registered Inspectors to access the system.
• Calculate the penalty fee on a rental that was returned late.
• Deploy Web App on Azure Platform and is accessible on the Web.
MARK ALLOCATION
Description Marks
A final version of your Web App with:
Good coding standards: Efficient code (no redundancy). 5
User interface: Appropriate controls employed to support web functionality. 5
Application functionality: Create, Read, update and Delete Cars, Inspectors, and Drivers. 10
Application functionality: Create and Retrieve new Rentals. 10
Application functionality: Create and Retrieve Returns 10
Application functionality: Only allow registered Inspectors to access the system. 10
Application functionality: Calculate the penalty fee on a rental that was returned late 10
Application functionality: Deploy Web App on Azure Platform and is accessible on the Web. 10
DETAILED RUBRIC FOR POE PART 3
RUBRIC 3 (POE Part 3) Levels of Achievement
In order to be awarded full marks for these elements of the POE, students need to have: Excellent Good Developing Poor
Score Ranges Per Level
Good coding standards: Efficient code (no redundancy). 4 – 5 3 – 4 2 – 3 0 – 2
User interface: Appropriate controls employed to support web functionality. 4 – 5 3 – 4 2 – 3 0 – 2
Application functionality: Create, Read, update and Delete Cars, Inspectors, and Drivers. 9 – 10 7 – 8 3 – 6 0 – 2
Application functionality: Create and Retrieve new Rentals. 9 – 10 7 – 8 3 – 6 0 – 2
Application functionality: Create and Retrieve
Returns 9 – 10 7 – 8 3 – 6 0 – 2
Application functionality: Only allow registered Inspectors to access the system. 9 – 10 7 – 8 3 – 6 0 – 2
Application functionality: Calculate the penalty fee on a rental that was returned late 9 – 10 7 – 8 3 – 6 0 – 2
Application functionality: Deploy Web App on Azure Platform and is accessible on the Web. 9 – 10 7 – 8 3 – 6 0 – 2
POE PART 3 SUBTOTAL /70

Published by

Dissertations

View all posts