HI5030 Business Systems Analysis and Design : Academic Integrity

HI5030 Business Systems Analysis and Design : Academic Integrity

$20 Bonus + 25% OFF

Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!

Students Who Viewed This Also Studied

HI5030 Business Systems Analysis and Design

Task:

Assessment Weight: 50 total marks

Instructions:

• All questions must be answered by using the answer boxes provided in this paper.

•  Completed answers must be submitted to Blackboard by the published due date and time.  

Submission instructions are at the end of this paper.

Purpose:

This assessment consists of seven (7) questions and is designed to assess your level of knowledge of the key topics covered in this unit

           

Case Study

A car rental company has several locations with different addresses. The cars are classified as Hatch, Medium, Sedan and Luxury. Each car has a particular make, model, year made and colour, as well as a unique identification number and a unique registration number.

Cars rented in one location may be returned to a different location (or drop-off) For every rental we keep a record of the odometer reading before it is rented and after it is returned. The car is rented with a full tank of fuel and we record the volume of fuel when the car is returned, but only indicate if the tank is empty, quarter full, half full, three quarters full or full.

We keep track of which day the car was rented, but not the time, and similarly for when the car is returned. Each car class has its own per-day pricing, but each car in the same class is priced the same. When the car is returned we record how many days the car was rented for  (return date – start date + 1). There is a drop-off charge also recorded if the car is dropped-off at a different location than it was rented from.

For our customers, we record their name, address, phone and drivers license number (which is unique for each person. When a car is rented there may be multiple drivers, and each of these is recorded against the rental car.

Question 1 ( 10 marks)

Draw an ER model using the crows-foot notation we used throughout the semester. Use Draw.io then cut and past your ER diagram into the answer box below

Question 2 (5 marks)

Provide a relational schema for the Database , (you will need to consult the appropriate lecture notes). Place your answers in the answer box below

Question 3 (10 marks)

Build the Database you have constructed in the ER Diagram in Questions 1 (and provided the relational schema for in Question 2) within PostgreSQL and supply the SQL DDL statements below (the Create Table SQL statements). Place your SQL DDL statements in the answer box below.

Question 4 (5 marks)

Construct some DML statements (SQL Insert statements) to insert some sample data in the tables you have constructed in Question 3 above. Place your SQL DML statements in the answer box below.

Question 5 (5 marks)

Construct an SQL Query to give the last name of all customers who currently have a rental car from our company. Place the SQL query and a cut and paste of the DBeaver result of the query in the answer box below.

Question 6 (5 marks)

Construct an SQL Query to give the make and colour of all cars currently rented out. Place the SQL query and a cut and paste of the DBeaver result of the query in the answer box below.

Question 7 (10 marks)

Construct an SQL Query to find the value of the cheapest (completed) rental. Place the SQL query and a cut and paste of the DBeaver result of the query in the answer box below.

End Of Final Assessment

Submission instructions:

•  Save submission with your Student Id Number And Unit Code e.g. EMV54897 HS2021 

•  Submission must be in Microsoft Word Format Only

•  Upload your submission to the appropriate link on Blackboard  

•  Only one submission is accepted.  Please ensure your submission is the correct document.

•  All submissions are automatically passed through SafeAssign to assess academic integrity.

HI5030 Business Systems Analysis and Design

Answer in Detail


Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

24 More Pages to Come in This Document. Get access to the complete answer.

buying coursework online from MyAssignmenthelp.com is the best decision you will ever make. Our coursework help services are packed with solid features such as 3000+ coursework experts, timely delivery, free revisions, plagiarism-free solutions and affordable prices. Our coursework writing services will always help you get the grades. You can call us to get expert help with your coursework.

More HI5030 HI5030 Business Systems Analysis and Design : Questions & Answers

Build a User Interface

Your task is to create a design prototype of the SES. You will be given the Enrolment Database in MS Access2010. Using the Layout Design features of MS Access Forms, create mock-up screens of the 9 modules included in the project. Be sure to make use of the objects, Fields, Labels, List Boxes, and C …

View Answer

Database Management System

Learning Outcomes AssessedThe following course learning outcomes are assessed by completing this assessment:ï‚· K4. design a relational database for a provided scenario utilising tools andtechniques including ER diagrams, relation models and normalisationï‚· K5. describe relational algebra a …

View Answer

ITECH2306 Agile Coding

Question:
Learning Outcomes
Skills:
1. Develop object-oriented programs involving several interacting classes.
2. Develop, compile and debug code using an appropriate IDE
3. Manage multiple versions of source code.
4. Select appropriate ways to represent data.
5. Incorporate pre-writt …

View Answer

Information Technology

This assessment task focuses on the following course objective: Use entity-relationship diagrams to design a relational database. …

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.

Choose Our Best Expert to Help You

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

HRM

Assignment: 6 Pages, Deadline:
22 days

I am really happy with the result, even though I had to make adjustments, and I got a good grade for it.

User ID: 5***20 France

Marketing

Home Work: 1 Page, Deadline:
3 days

Thank you so much! taking a time to do Thank you so much! taking a time to do my assignment my assignment

User ID: 6***98 United States

Assignment

Essay: 4.8 Pages, Deadline:
10 days

A very well presented assignment, all the ideas were very well explained, easy to understand. Definitely will recommend .

User ID: 8***07 Denmark

Business Law

Home Work: 0.9 Pages, Deadline:
1 day

Thank you, very much ????????????! I’m looking forward to working with you guys again.

User ID: 8***94 Canada

Medical

Essay: 1.6 Pages, Deadline:
3 days

This assignment was good I got a really good grade on this assignment so who complete this one great job.

User ID: 8***56 United States

Pharmacy

Assignment: 1 Page, Deadline:
3 days

This assignment was okay but I felt that it could have gotten a better grade but assignment was good.

User ID: 8***56 United States

Marketing

Home Work: 1 Page, Deadline:
11 days

Very reliable work. I liked the quality of assignment. They delivered two days before the day of commitment.

User ID: 8***50 Australia

Management

Assignment: 6 Pages, Deadline:
5 days

Good work and very fast turn around. Happy with the quality of assignment. Definitely would recommend.

User ID: 8***50 Australia

Assignment

Essay: 2 Pages, Deadline:
3 days

Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.

User ID: 5***21 Blanchardstown, Ireland

Statistics

Home Work: 3 Pages, Deadline:
11 hours

Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !

User ID: 8***32 Blanchardstown, Sri Lanka

Civil Law

Home Work: 3.6 Pages, Deadline:
4 hours

Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time

User ID: 8***31 United Kingdom, Great Britain

Economics

Home Work: 1.2 Pages, Deadline:
2 hours

Thanks for helping at short notice. Great quality, in the short time provided. All the best

User ID: 8***61 United Kingdom, Great Britain

Management

Assignment: 5 Pages, Deadline:
5 days

This report addresses the assignment brief very well, with much detail on Unilever online presence. The recommendation are good, and more detail/ less …

User ID: 8***01 England, Great Britain

Maths

Home Work: 1 Page, Deadline:
54 minutes

Super quick response time, great detail and construction of the solution. Many thanks for your help in this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

The new answer seems correct and is well explained in detail. Thank you for reviewing the work and for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

Very good solution, well explained in detail. Thank you very much for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Finance

Essay: 4 Pages, Deadline:
7 days

Awesome work! I am fully satisfied with the quality of the content. The writers worked hard to deliver such a deep and wide content. Keep it up.

User ID: 8***46 Batu Caves, Malaysia

Nursing

Assignment: 1 Page, Deadline:
4 days

This powerpoint was neat and concise. The expert definitely followed through with what was asked.

User ID: 6***42 Batu Caves, United States

Nursing

Assignment: 12 Pages, Deadline:
5 days

well written assignment. good references and all done in a timely manner. pricing was good and support available when needed

User ID: 6***93 United Kingdom, Great Britain

Maths

Course Work: 0.4 Pages, Deadline:
2 hours

Great, very clear, thank you very much For your help on this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

HRM

Assignment: 6 Pages, Deadline:
22 days

I am really happy with the result, even though I had to make adjustments, and I got a good grade for it.

User ID: 5***20 France

Marketing

Home Work: 1 Page, Deadline:
3 days

Thank you so much! taking a time to do Thank you so much! taking a time to do my assignment my assignment

User ID: 6***98 United States

Assignment

Essay: 4.8 Pages, Deadline:
10 days

A very well presented assignment, all the ideas were very well explained, easy to understand. Definitely will recommend .

User ID: 8***07 Denmark

Business Law

Home Work: 0.9 Pages, Deadline:
1 day

Thank you, very much ????????????! I’m looking forward to working with you guys again.

User ID: 8***94 Canada

Medical

Essay: 1.6 Pages, Deadline:
3 days

This assignment was good I got a really good grade on this assignment so who complete this one great job.

User ID: 8***56 United States

Pharmacy

Assignment: 1 Page, Deadline:
3 days

This assignment was okay but I felt that it could have gotten a better grade but assignment was good.

User ID: 8***56 United States

Marketing

Home Work: 1 Page, Deadline:
11 days

Very reliable work. I liked the quality of assignment. They delivered two days before the day of commitment.

User ID: 8***50 Australia

Management

Assignment: 6 Pages, Deadline:
5 days

Good work and very fast turn around. Happy with the quality of assignment. Definitely would recommend.

User ID: 8***50 Australia

Assignment

Essay: 2 Pages, Deadline:
3 days

Very quick done and professional job. Helped me to gain good marks. Easy to read as answers given very clear.

User ID: 5***21 Blanchardstown, Ireland

Statistics

Home Work: 3 Pages, Deadline:
11 hours

Thank you very much… YOU ARE A GREAT WRITER ! You provide this answer and saved my life !

User ID: 8***32 Blanchardstown, Sri Lanka

Civil Law

Home Work: 3.6 Pages, Deadline:
4 hours

Thanks for the time response and helped me in successfully submitting the assignment. Thanks for this time

User ID: 8***31 United Kingdom, Great Britain

Economics

Home Work: 1.2 Pages, Deadline:
2 hours

Thanks for helping at short notice. Great quality, in the short time provided. All the best

User ID: 8***61 United Kingdom, Great Britain

Management

Assignment: 5 Pages, Deadline:
5 days

This report addresses the assignment brief very well, with much detail on Unilever online presence. The recommendation are good, and more detail/ less …

User ID: 8***01 England, Great Britain

Maths

Home Work: 1 Page, Deadline:
54 minutes

Super quick response time, great detail and construction of the solution. Many thanks for your help in this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

The new answer seems correct and is well explained in detail. Thank you for reviewing the work and for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Maths

Home Work: 1 Page, Deadline:
1 hour

Very good solution, well explained in detail. Thank you very much for your help on this assignment. All the best.

User ID: 8***61 United Kingdom, Great Britain

Finance

Essay: 4 Pages, Deadline:
7 days

Awesome work! I am fully satisfied with the quality of the content. The writers worked hard to deliver such a deep and wide content. Keep it up.

User ID: 8***46 Batu Caves, Malaysia

Nursing

Assignment: 1 Page, Deadline:
4 days

This powerpoint was neat and concise. The expert definitely followed through with what was asked.

User ID: 6***42 Batu Caves, United States

Nursing

Assignment: 12 Pages, Deadline:
5 days

well written assignment. good references and all done in a timely manner. pricing was good and support available when needed

User ID: 6***93 United Kingdom, Great Britain

Maths

Course Work: 0.4 Pages, Deadline:
2 hours

Great, very clear, thank you very much For your help on this assignment. All the best

User ID: 8***61 United Kingdom, Great Britain

Have any Query?

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