Download Database Design & Implementation: Practical Group Project for FNDS015 and more Assignments Information Technology in PDF only on Docsity!
Assessment Item
Assignment 2: Designing and Creating a simple Database +
Presentation
This assignment is based on learning materials covered in week 7 – week 10.
Weighting: 15%
Due date: Week 13 during class
Assignment Type: PRACTICAL GROUP PROJECT (groups of 2 only)
Submission method: As instructed by teacher
Instructions:
Part A:
- Start a new Word document and add your full student name and ID as a header to appear on every page.
- Save this document as your ‘student ID+ASSIGN-2’.
- Prepare an entity relation diagram (ERD) for the case below:
Use the ‘crow’s foot’ notations in your ERD and indicate the type of relationships.
Business case for ERD:
Overview of business case:
ABC Reality is a real estate business that provides a property management service to clients. They also sell properties and manage rentals. They never had a database before and have a lot of paper records and files stored in filing cabinets. As their business is expanding and more data is been gathered, they decided to investigate the option of implementing a database system. Accordingly, they asked you to design a database system to keep track of their business activities.
Your task
Create an ERD for each of the following statements that describe the current business rules for ABC. For each new statement being the business rule, extend the ERD to include the additional business rule in the ERD (created in previous point - for example; B will include A&B; C will include A, B & C, etc.)
Use Crows Foot notations and include all the following in each part:
All entities with Primary key and any foreign key attributes; The relationships between entities; The cardinality and optionality of each relationship; Any M:N relationships are be resolved to 1:M relationships
sample business rules for your ERD:
A. Each sales agent may sell or mange the rental of a number of properties: property address and listing date is required. Also who is the owner of the property, being the client. B. Each client may have a number of properties for rent or for sale. C. Each agent is assigned to manage between 3-10 properties, but a property is always managed by the one agent. D. When a tenant pays rent for a property, a record of their payment is recorded and the date of the payment. E. Sometimes repairs on rental properties is needed: in this case the tenant will make a request for some repairs to the agent. F. The managing agent of ABC Reality will hire the right tradespeople to do the repairs. Information about the repairs of each property needs to be recorded.
For the final ERD, you need to use appropriate drawing software: https://www.gliffy.com/ , https://www.draw.io/ or http://creately.com/ are acceptable.
- You will need to copy the diagram using a screen shot (PrintScrn) into the Word document ‘student IDs+ASSIGN-2’ you created earlier in point 2.
- Under the diagram (In Word), type a brief description of the relationships you have used and what business rules were these based on.
- Save your document and submit as instructed by the teacher.
Refer to Submission Instructions on page 4
Create a Report
Create a report based on any one of the queries you saved earlier and use your own design and layout. Modify the look of the report and place a graphic of a house (find this image from online search) Save as ‘report-Done.
Presentation:
Prepare a PowerPoint presentation to demonstrate and explain how you achieved the work of this assignment: Include screen shots of some parts and step-by-step instructions. Each group member must speak for 2 minutes.
No Marks will be given to students who do not work equally in this group assignment and those who do not take part of the presentation.
Submission Instructions:
- Save all your work.
- Create a folder with your student IDs-As-2 as the name
- Place all assignment 2 files in this folder and be ready to present for marking.
****This assignment will be marked by the teacher in the practical class of week 13, so be sure to have your files ready.**
End of assignment 2 instructions
