Find Jobs
Hire Freelancers

Database Modelling Uni Assignment

$30-250 AUD

Completed
Posted over 5 years ago

$30-250 AUD

Paid on delivery
Rationale This assignment has been designed to assess students’ ability to model data, by constructing an entity-relationship diagram for a particular business scenario. This assignment addresses the following learning objectives for this subject: • Perform conceptual modelling using Entity-Relationship Diagrams (ERDs) • Discuss business assumptions which affect data modelling. Model a database using the entity-relationship (ER) model and understand the database development process • Use the techniques of normalization Tasks • You are to write a brief discussion of your solution, i.e. how you approached the modelling problem and any issues you may have encountered (maximum of ½ page). • You are to write all applicable business rules necessary to establish entities, relationships, optionalities, connectivities, cardinalities and constraints. If a many–to-many relationship is involved, state the business rules regarding the bridging entities after breaking down the many-to-many relationship. An example business rules format can be found in Appendix A of this document. Business rules you write are expected to be in the same format as presented in Appendix A. • Based on these business rules,* draw a fully labelled and implementable Entity-Relationship Diagram (ERD). Include all entities, relationships, optionalities, connectivities, cardinalities and constraints. You must use Crow’s foot notation and MS Visio to create the ERD (a hand-drawn ERD will NOT be accepted). A sample ERD can be found in Appendix A of this document. (Note: The ERD created using Visio will need to be saved as an image file and then be included in your document file to be submitted). • A summary to describe the major justifications, assumptions and limitations related to your database design. For example: • Assumption/justifications for optionalitiy, connectivities, constraints data type and data domain; and • Special cases or data integrity issues that cannot be handled. Note: Designing the database is an iterative process; you may find yourself going back and forth between Tasks 1 and 3 to revise the design. Make sure that your final submission shows consistent design in the business rules and ERD. Submission • need to submit a document file (MS Word format); this document should include all the answers for tasks 1-4. • need to submit the MS Visio file containing the ERD. •. assignment submission will be used to determine if the assignment is late or not. Refer to the subject guide for the policy for late submission.
Project ID: 17584744

About the project

18 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I, Jignesh Lakhani completed my masters from IIT Roorkee in Computer Engineering. I am having a very good knowledge of C, C++, Java, and Database Management System. I am having strong analytical power. I will complete your project before the deadline. I am looking forward to discussing with you this job post. Please feel free to contact me. Respectfully, Jignesh
$138 AUD in 3 days
4.5 (3 reviews)
3.5
3.5
18 freelancers are bidding on average $122 AUD for this job
User Avatar
I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.
$155 AUD in 3 days
4.7 (164 reviews)
6.8
6.8
User Avatar
Hello Sir/Mam, I have 5+ years experience in Database Administration, Database Development, Database Programming, Research Writing, UML Design. I will make all the submissions i.e: • need to submit a document file (MS Word format); this document should include all the answers for tasks 1-4. • need to submit the MS Visio file containing the ERD. •. assignment submission will be used to determine if the assignment is late or not. Refer to the subject guide for the policy for late submission. I would really appreciate if we can quickly communicate via chat. Thanks.
$100 AUD in 3 days
4.8 (247 reviews)
6.7
6.7
User Avatar
Hello Dear, I have seen complete project description and I can complete this work as I am having 5+ years working experience in Database Administration, Database Development, Database Programming, Research Writing, UML Design. I would really appreciate you if you will make small conversation once. Thanks
$150 AUD in 3 days
4.8 (127 reviews)
6.5
6.5
User Avatar
Hi, I am a UK University (Liverpool John Moores University) Graduate. I am seeking this opportunity to assist you in your project. I can assure you “Quality” writing. Let us discuss more about the project. I have 100% positive reviews in FL account because Quality is always in the first Place for me. I have experience of academic, business article and science related writing since 2008.
$155 AUD in 3 days
4.8 (142 reviews)
6.5
6.5
User Avatar
Designed and Developed many systems and solutions. Contact me with more details. I am interested. Thanks
$155 AUD in 3 days
4.9 (45 reviews)
6.0
6.0
User Avatar
Hi there, I went through the requirements and I would like to do this project if given the opportunity. I do Database modelling. Let me know if you are interested.
$50 AUD in 1 day
4.9 (97 reviews)
5.6
5.6
User Avatar
- Have expertise in Data modelling, ERD diagram using Normalisation 3NF. - Designed databases for different business scenario and also few of the assinments. Can provide the documentation with - Conceptual Design Logical Design (Relationship diagram) ERD - 3 Normal form. - Documentation with the assumption, constraints in arriving at the solution. - All this in word document. My Skills: - I have very good expertise in MS Access - GUI, Data entry forms, calculations and reportings. - Worked on projects Database designing from business proposal, ER diagram, creating Entity relationship, normalization, constraints, indexes. - Please review my portfolio on the recent projects in Excel and MS Access. - MS Access - Database creation, tables, forms, queries and reports. Form designing, report designing, Reports generation.
$160 AUD in 3 days
4.7 (12 reviews)
4.3
4.3
User Avatar
Hello there, I'm Houda, engineer in information system, I actually work with the database and datawerhouse, so modeling data is my job, I can do academic tasks like yours, especially Entity Relational Diagram with all rules and assumptions according to relational algebra and specifications in your work, I can also transform this diagram to logical model respecting the migration of primary key and foreign key, that interprets the structure of the schema of database, for the software I have already worked with Ms-vision. Feel free pleases and contact me for more details, I will be glad to offer you my services. Regards!
$100 AUD in 3 days
5.0 (10 reviews)
3.7
3.7
User Avatar
Please see my profile for ratings and similar projects.
$155 AUD in 1 day
4.9 (9 reviews)
3.3
3.3
User Avatar
Hello, I have despicable past experience and excellent work record with regards to making dashboards in PowerBI, Tableau, Sisence and other BI Tools. I have developed several Dashboards and I am ready to show some past samples that I developed. I have excellent time management skills and I am ready to negotiate to accept a lower price. Kindly reply my request. Thank you
$77 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Have gone through your requirements and feel can do the job for you. I have 15+ years of experience in software development and database modeling. Kindly consider. Thanks, UK Sharma
$100 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I  am into providing web and mobile and database software development and consulting solutions  to enterprises.i do have industry expertise in design and development specialized in delivery of quality software solutions to my customers. The initial review on your requirement indicate that this works could delivered to your satisfaction based on my confidence on experience and expertise. I hope you would consider this proposal and initiate a discussion with me soon to look at getting engaged with further on this project. thanking you Martin
$116 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been a professor and have taught data modelling and design subject to students at engineering college. Can take up the task and help you with my knowledge. Let me know if we can collaborate Thanks!
$55 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I have very good grip on database. Have done RA, ERD, normalization each and every thing of databases. We can discuss the bid and deadline. New on this site but proper freelancer on upwork that's why I review. Kindly give me the opportunity to work with you. I provide quality work. Regards, HAMMAD RAUF
$100 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
sydney, Australia
5.0
1
Payment method verified
Member since May 17, 2018

Client Verification

Other jobs from this client

DATA MINING
$30-250 AUD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.