
Abgeschlossen
Veröffentlicht
Bezahlt bei Lieferung
Assessment: Database design Required: Design and specify a relational database for a specific topic of your choice. The scenario must not replicate any examples used in tutorials, exercises, or assessments in this module. You may choose your own topic, provided it requires a comparable level of complexity. Credit will be given for models that are specialised to your chosen scenario rather than generic designs. Example topics might include: • Hobbies (e.g., sports, hiking, climbing) • Reviews (e.g., books, films, restaurants, travel, music) • Library catalogues • E-commerce systems • Electronic health records Assessment Guidance You will create a conceptual and logical database design using Draw.io. Your database model must: • Contain at least four entities • Include at least one event/action entity • Ensure each entity has at least two attributes • Fully specify all primary keys You will then translate your conceptual design into a relational model. 1. Scenario description and example queries (10 marks) • Write a clear, 100-word description of your proposed system. • Provide five example SQL query statements showing how the database would be used. Marks are awarded for clarity, relevance, and alignment between the scenario and the proposed queries. 2. Conceptual model – entity relationship diagram (40 marks) Create an ERD using Draw.io. The diagram must: • Identify all entities required by your scenario. • Include at least one event/action entity. • Define attributes for each entity. • Clearly indicate primary keys. • Show all relationships between entities. • Specify multiplicity (e.g., one-to-many). • Specify optionality (mandatory or optional participation). All entities and relationships necessary to support your five example queries must appear in the model. Marks are awarded for completeness, correctness, clarity of modelling, and appropriate use of notation. 3. Logical relational model (30 marks) Translate the ERD into relational tables using the mapping rules covered in the module. You must: • Correctly assign primary keys. • Clearly specify foreign keys. • Ensure consistency with the conceptual model. Marks are awarded for correct mapping and structural accuracy. 4. Design justification (20 marks) Provide a short, written justification (maximum 300 words) explaining: • Key modelling decisions. • Any assumptions made. • How the model supports the example queries. Marks are awarded for analytical reasoning and demonstration of thinking. (Total – 100 marks) Word count: Maximum 600 words (-/+10%). No word limit applies to diagrams, relational tables, or SQL query statements.
Projekt-ID: 40270179
64 Vorschläge
Remote Projekt
Aktiv vor 15 Tagen
Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten

Hi, I'd be happy to help with your database design assessment. I'm thinking of going with an Automated Parking Management System — it covers parking facilities, vehicle tracking, permits, and payments. It fits the brief well: at least five entities, a clear event entity (parking sessions), and plenty of scope for meaningful SQL queries — without overlapping with common tutorial examples. I'll deliver all four sections as specified: scenario with queries, ERD in [login to view URL], logical model, and design justification. Let me know if you'd like a different topic or have any preferences before I get started. Best, Ken
£250 GBP in 7 Tagen
4,1
4,1
64 Freelancer bieten im Durchschnitt £429 GBP für diesen Auftrag

Hi, how are you today? I can provide you with the solution to the problems such that you will get the maximum grade.
£300 GBP in 4 Tagen
6,5
6,5

Hello Dear! I write to introduce myself. I'm Engineer Toriqul Islam. I was born and grew up in Bangladesh. I speak and write in English like native people. I am a B.S.C. Engineer of Computer Science & Engineering. I completed my graduation from Rajshahi University of Engineering & Technology ( RUET). I love to work on Web Design & Development project. Web Design & development: I am a full-stack web developer with more than 10 years of experience. My design Approach is Always Modern and simple, which attracts people towards it. I have built websites for a wide variety of industries. I have worked with a lot of companies and built astonishing websites. All Clients have good reviews about me. Client Satisfaction is my first Priority. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB What you'll get? • Fully Responsive Website on All Devices • Reusable Components • Quick response • Clean, tested and documented code • Completely met deadlines and requirements • Clear communication You are cordially welcome to discuss your project. Thank You! Best Regards, Toriqul Islam
£250 GBP in 4 Tagen
4,9
4,9

I’ve spent years architecting high-performance relational schemas, recently delivering a complex multi-tenant ERP database that optimized query execution by 40% through advanced normalization. Your requirement for a precise relational database design suggests a need for a professional who understands how to future-proof data structures against evolving business logic. I excel at translating abstract functional requirements into rigid, high-integrity relational models that serve as a reliable backbone for your specific software application or analytical system. My process starts with a thorough analysis of your business entities to establish clear primary/foreign key hierarchies and enforce referential integrity across all modules. I will develop a comprehensive Entity Relationship Diagram (ERD) documenting every relationship and cardinality using industry-standard tools like MySQL Workbench. Beyond the visual schema, I provide optimized Data Definition Language (DDL) scripts, including tailored indexing strategies and constraints. I prioritize 3NF normalization to eliminate redundancy while selectively denormalizing for performance if your use case requires high-speed read operations. Could you clarify the core business topic and the expected data volume, as this will influence the partitioning and indexing strategies I propose? Also, do you have a specific RDBMS preference like PostgreSQL or MySQL to ensure the DDL scripts are optimized for your stack? I am ready to discuss these technical nuances in a brief chat to ensure the final specification meets your exact project goals, and I am available to begin the architectural design phase immediately.
£617 GBP in 21 Tagen
4,5
4,5

Hi there,Good afternoon I am Talha. I can work with your project skills Database Design, Relational Databases, Database Programming, Database Development, Data Modeling, Database Administration, Data Analysis, Data Architecture, SQL and Database Management I am excited to present my proposal, which centers around a personalized approach designed to elevate your project. We will start with an in-depth consultation to gain a deep understanding of your project's unique requirements, goals, and constraints. Our commitment to customization means that we will tailor our services to align perfectly with your project, and we will explain how this approach will meet your expectations. Please note that the initial bid is an estimate, and the final quote will be provided after a thorough discussion of the project requirements or upon reviewing any detailed documentation you can share. Could you please share any available detailed documentation? I'm also open to further discussions to explore specific aspects of the project. Thanks Regards. Talha Ramzan
£250 GBP in 12 Tagen
4,3
4,3

Respected Sir/Madam, I am an IT Professional, Business Analyst and Database expert with over 8 years’ experience here….i will provide u perfect data base assignment done using conceptual/logical diiagram, description SQL queries etc. as perm entioned description. In the past I have completed more than 280 projects related to business process diagrams, UML, BPMN and technical documentations. I am expert in process flow diagrams including use cases, ER diagram, sequence diagrams, class diagrams, data flow diagrams, collaboration diagrams, activity diagrams, wireframes, data dictionaries, decision tables, flowcharts, choreography diagrams etc. the related tools I worked in are: MS Visio, Lucidchart, visual paradigm, StarUML etc. The technical documents I have done includes system documentations, user stories, test cases, SRS, TRS, BRD etc. I will provide u great quality of work with 100% accuracy on the desired time. Revisions: unlimited until satisfaction Rating: 836 positive client feedbacks Portfolio: www.freelancer.com/u/Nidagold.html Thank you so much!
£350 GBP in 3 Tagen
4,1
4,1

Hi, I can help you produce a high-quality database design assessment with strong alignment between scenario, ERD, queries, and relational model. The design will include at least four entities, one event/action entity, clearly defined primary/foreign keys, multiplicity, and optionality. I focus on structural accuracy and analytical justification to maximise marks across all sections. Let’s choose a specialised topic and build a clean, academically solid submission. — Munish Gupta
£250 GBP in 3 Tagen
3,5
3,5

Hi, I have read about your requirements and we are happy to inform that we at tecnogize have done numerous database designs like this and would love to do this for you! let's discuss more over chat and see what you have in mind!
£700 GBP in 7 Tagen
2,4
2,4

Hi, There is strong interest in the project and full support can be provided to ensure its successful progress. I understand what you need and can start with a clear plan to reach your goals. I have 5+ years of experience in SQL. I have completed similar projects. I have a few questions before we get started. Could you please send me a message in the chat? If you like my approach, please connect in chat. Talk soon, Dax Manning
£555 GBP in 7 Tagen
2,0
2,0

⭐⭐⭐⭐⭐ Hi , Good evening! I Understand Exactly What You Want. I've reviewed the job description carefully. This is similar to my previous project and I can share it if needed. I am professional developer engineer with skills including Database Development, SQL, Data Analysis, Database Design, Database Programming, Relational Databases, Data Architecture, Database Management, Database Administration and Data Modeling. Please send a message to discuss more about this project. Thanks & Regards
£350 GBP in 1 Tag
1,2
1,2

As a Fullstack Developer, my proficient knowledge of databases and immense experience in database development and design make me an ideal candidate for your project. Over the years, I've been involved in developing complex ERP web and mobile applications, utilizing databases like MySQL, PostgreSQL, and MongoDB, similar to what your project entails. Moreover, I've also worked extensively on various domains such as the mining industry, textile industry, chemical sales industries, etc., appreciably expanding my repertoire for handling diverse projects. Applying my expertise to your project would guarantee an efficient and innovative database design that meets your needs while adhering to best practices. My mastery over programming languages like PHP and Python allows me to fluently understand and fabricate SQL queries, aligning with your requirement of offering five example SQL query statements showcasing the usage of the database. I understand the importance of clarity, relevance, and alignment when presenting/proposing database models for specific scenarios - aspects that you duly prize in this project. My clients have often found solace in my problem-solving skills and aptitude for thinking analytically during crucial stages of design justification. These attributes will come in handy in providing a comprehensive written explanation about key modeling decisions as well as the logic behind certain assumed assumptions for your relational database. With impeccable mapping skills and a knack for structural accuracy teasing out from my experience with ERP systems integration duties and more recently with IoT
£500 GBP in 10 Tagen
1,0
1,0

Hi, I can design a complete, high-quality relational database tailored to your chosen scenario, fully aligned with your assessment requirements. I will provide: 1. Scenario description and example queries – a clear 100-word overview plus five SQL queries demonstrating typical usage. 2. Conceptual ERD – at least four entities (including one event/action), all attributes, primary keys, relationships with multiplicity and optionality, created neatly in Draw.io. 3. Logical relational model – tables with correct primary and foreign keys, fully consistent with the ERD. 4. Design justification – a concise written explanation (≤300 words) covering modelling decisions, assumptions, and how queries are supported. I ensure the database is specialised to your scenario rather than generic, with thoughtful attribute choices, precise relationships, and full query support. The deliverables will be clear, well-documented, and ready for submission, demonstrating strong analytical reasoning and adherence to module standards. I can complete this efficiently while maintaining clarity, correctness, and alignment with assessment criteria. Thanks, Giang V
£500 GBP in 7 Tagen
0,4
0,4

Hello, I am Vishal Maharaj, with 20 years of experience in SQL, Database Programming, and Database Development. I have carefully reviewed the requirements for the project involving designing and specifying a relational database for a specific topic. To successfully complete this project, I will start by creating a conceptual and logical database design using Draw.io. The database model will include at least four entities, one event/action entity, two attributes for each entity, and fully specified primary keys. I will then translate the conceptual design into a relational model, ensuring correct assignment of primary and foreign keys. I will provide a clear scenario description, example SQL queries, an entity relationship diagram, relational tables, and a design justification to support the modeling decisions. Please initiate a chat to discuss this project further. Cheers, Vishal Maharaj
£500 GBP in 5 Tagen
0,0
0,0

Hello, I will design a relational database for a focused, non-tutorial topic that balances concepts like entities, events, and relationships. The deliverable includes a conceptual ERD with at least four entities and an event/action entity, a logical relational model with primary/foreign keys, five example SQL queries, and a compact design justification. I can start immediately. Best Regards Jeric
£250 GBP in 4 Tagen
0,0
0,0

Hello, I would like to grab this opportunity and will work until you are 100% satisfied with my work. I am an experienced professional with many years of hands-on experience in SQL, Database Administration, Database Programming, Database Development, Data Analysis, Data Architecture, Relational Databases, Database Design, Database Management, Data Modeling Please come over chat and discuss your requirement in a detailed way. Regards, Rajesh Rolen
£500 GBP in 7 Tagen
0,0
0,0

Hi, I can design a well-structured relational database tailored to a unique and specialised scenario (not a generic tutorial example). I’ll choose a topic with enough real-world complexity and clearly justify the design decisions. The work will include: Clear scenario description Identified entities and attributes Proper primary and foreign keys Well-defined relationships (1–1, 1–M, M–M) Normalization (up to 3NF where appropriate) ER diagram Relational schema Assumptions and design explanation I’ll make sure the database design is logical, realistic, and academically strong, so it stands out from common examples used in class materials. Let’s discuss your required format (report, diagrams, SQL included or not) so I can align it exactly with your grading criteria. Best regards,
£300 GBP in 7 Tagen
0,0
0,0

hi, I have the skills necessary to successfully complete your project. My expertise includes database creation and design from scratch, proficient understanding of SQL, and excellent competency with mapping large datasets accurately. Clearly indicating primary keys is one of my core specializations. Having worked on multiple projects like yours within industries such as Healthcare & Fintech Systems, I’m confident that I can deliver a final product that aligns with your specific needs and supports the example queries you've provided. To ascertain continuity between your conceptual design and its relational model, you need someone who can seamlessly translate the conceptual ERD into accurate relational tables. This specifically involves correct assignment of primary keys, clearly specifying foreign keys, and ensuring consistency with the conceptual model-all skills which I possess and have successfully deployed over the course of my career. Therefore you can be assured that I will deliver an on-time and on-budget execution. Looking forward to partnering with you for a long-term scalable solution
£500 GBP in 7 Tagen
0,0
0,0

Bonjour, Entrepreneur passionné et rigoureux, je mets mon expertise en [indiquez votre domaine principal] au service de projets ambitieux. Mon approche repose sur trois piliers : la clarté de la communication, la réactivité et un engagement total envers la qualité des résultats. Fort d'une expérience solide en [citez 2 ou 3 compétences clés], j'accompagne mes clients avec une vision stratégique et responsable, en veillant toujours à proposer des solutions sur-mesure et pérennes. Collaborer avec moi, c'est choisir un partenaire de confiance, dédié à la réussite de vos objectifs avec le plus grand respect de vos délais et de vos exigences professionnelles. Au plaisir d'échanger sur votre prochain projet,
£500 GBP in 7 Tagen
0,0
0,0

Hello, I can design a structured relational database with ER diagrams, normalization, and example SQL queries. As a possible modern topic, we could use an **E-Sports Tournament Management System**. It would include entities such as Players, Teams, Tournaments, Matches, and Scores, allowing clear relationships and proper normalization. Of course, the full design would be developed from scratch according to your requirements. If you already have a preferred topic, please let me know. Best regards
£400 GBP in 4 Tagen
0,0
0,0

Hello sir, I can design a specialised relational database model with full conceptual ERD, logical schema mapping, example SQL queries, and structured justification within the 600-word limit. With 5+ years in database architecture and normalization, I will create a non-generic scenario including at least four entities and a clear event/action entity, define primary/foreign keys, multiplicity, optionality, and ensure every query is fully supported by the model. I focus on academic grading criteria and clean documentation. Do you have a preferred topic area? What citation style is required? If I am lucky enough to capture your attention, please don't hesitate to contact me. We can engage in a 10-15 minute discussion via messages to delve deeper into the project requirements and cover all aspects.
£380 GBP in 1 Tag
0,0
0,0

I am Rashidab , I am ready to start work right now. I will design a specialised relational database with a unique scenario such as an adventure travel booking system. The project will include a clear scenario description, five aligned SQL queries, a complete ERD with at least four entities and one event entity, fully defined primary and foreign keys, multiplicity and optionality, a logical relational model, and a strong design justification, all within required word limits and academic standards.
£500 GBP in 7 Tagen
0,0
0,0

Leyton, United Kingdom
Zahlungsmethode verifiziert
Mitglied seit Dez. 25, 2019
£20-250 GBP
£20-250 GBP
$3000-5000 USD
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
£10-15 GBP / Stunde
€750-1500 EUR
min. $50 USD / Stunde
$250-750 USD
$15-25 USD / Stunde
$250-750 USD
₹1500-12500 INR
₹12500-37500 INR
$1500-3000 USD
₹12500-37500 INR
$25-50 USD / Stunde
$30-250 USD
$10-100 USD
$10-30 AUD
$10 AUD
₹1500-12500 INR