COMM226: Introduction to Business Technology Management-IT Assignmnet Help

Important

1. You need to complete this assignment in a team of two members (from the same section)
2. Plagiarism, as defined in the course outline, will result in an automatic 0% grade on this assignment for team members.
3. We will follow the penalty guidelines for late submissions as stated in the course outline.

Allow enough time to complete this assignment, you are responsible for starting this assignment early enough to receive help in case you encounter technical issues. Bear in mind that you will have a hard time getting support if you decide to start the assignment one day before it is due.

Case:

Please use the following case to answer Q1 and Q2 in this assignment.

• Rapidity is a scooter rental company who offers rental scooters to its customers in Toronto. They have several scooters rental offices where scooters can be parked and found in these stations.
• Each scooter is identifiable with their brand, registry number, 5digit-ID (format: AA111), date of purchase, and date of production.
• Each rental office is described by its geographical location (i.e., the street name, longitude, and latitude), and a unique 4-digit ID (format: 1111).
• To handle the operations, different departments are involved in this process, such as accounting, operation, and scooter management. In each department there could be no employees (automated) to 10 employees.
• If there are not any scooters in the rental office, or there are damaged scooters in the rental office, the scooter management department will replace scooters and repair the damaged ones.
• There are two types of users/customers (unregistered, and registered users) and only registered users can request a scooter. Registered users should provide their personal information and their payment information.
• There are two types of rental requests: registered users’ rental requests and onetime rental (i.e., unregistered users) requests. Registered users can take a scooter for free, limited to 40 minutes, and for more than 40 minutes, they should pay an extra fee of 2$ per hour. For one-time rental requests (i.e., unregistered users), initially, they should pay 80$ as a deposit and their hourly rate begins from the moment of usage which is 2$ per hour. After returning the scooter, the deposit will be returned to them.
• For membership request, users must buy a monthly membership for 38 dollars.
• They can also buy a family membership (membership for up to 4 people) for 90 dollars.
• No customer can use a scooter for more than 90 hours in one rental request.
• For each usage, the rental office keeps track of the date of request, the date the scooter is returned, scooter information, customer information (e.g., name, address, telephone number), and the rental total charged amount.

Questions:

Q1: Data Management: Entity Relationship Diagram & MS Access 

a. Draw the ERD of the database that could be used to support the operations of the business described in the case.

The ERD should identify:

• Primary keys and Foreign keys;
• Entities and at least three Attributes for each entity;
• Relationships and Cardinalities (e.g., one-to-one, one-to-many).

Next to the ERD in your submission, list the assumptions made when designing the ERD. If an element of the above case does not provide the information necessary to know which design choice should be made over another, the choice you make will be accepted if it correctly reflects your assumptions.

HINT: Many-to-many relationships must be split into two one-to-many relationships.

b. Create the data dictionary for your database. To do this, you can use the template given with this assignment (datadictionaryTemplate.xls)

c. Implement the ERD using Microsoft Access 2010/2013/2016/2019 or LibreOffice

 Microsoft Access is installed in the SCBTM computer labs. LibreOffice can be downloaded from the link below (Windows or Mac): 

Using the ERD and data dictionary that you created previously, complete the following

steps: 1. Implement the ERD and data dictionary in Microsoft Access 2010/2013/2016/2019 or LibreOffice. The Microsoft Access Database should have all the tables, attributes, and relationships defined in your ERD and data dictionary. You should make sure that all the primary keys and foreign keys are defined.

Q2: Process Management: Process Mapping.

a. Draw a Flowchart diagram depicting processes in the case. Your diagrams must depict the following:

• Main actions / processes
• Main decisions
• Actors (departments) with dedicated swimlanes Submission:

This COMM226: IT Assignmnet Help has been solved by our IT experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.