I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation.
I need a 2000-word report + 15-20 slides presentation
Objective:
This assignment aims to enhance your understanding of database design through the practical
application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work
in groups to design a database system that is both efficient and scalable, addressing a real-world
problem scenario provided below.
Assignment Scenario:
Your team has been tasked with designing a database system for one of the scenarios listed
according to your group number; if you are in group N, you must choose scenario N. For example,
Group 10 must choose Scenario 10. If you work on a different scenario, your assignment will not
be marked.
Your database should provide a comprehensive solution that allows for efficient data retrieval,
updates, and integrity.
Deliverables:
a. Entity-Relationship Diagram (ERD):
Construct a detailed ERD that represents the scenario. Your ERD should include all necessary
entities, relationships, attributes, and primary keys. Use appropriate notation to indicate
relationships, cardinality, and participation constraints clearly.
b. Normalization:
Provide a detailed explanation of how you applied normalization techniques to ensure that
your database design is free of redundancy and update anomalies.
Your submission should include:
The process of normalizing your database design to at least 3NF (Third Normal Form).
Identification of any potential issues you encountered during normalization and how you
resolved them.
c. SQL Schema:
- Create an SQL schema that includes defined entities.
- Define primary keys, foreign keys, and appropriate constraints.
- Ensure that the database schema enforces referential integrity.
You need to create all of the above things from one of them (I will specify in chat):
Scenario 3: Public Library Management
Create a database for a public library to manage books, members, loans, and fines. The database
should handle book reservations, track overdue items, and support queries for book availability
and member activity.
Scenario 15: Music Festival Organization
Design a database for organizing music festivals, including artists, stages, schedules, and ticket
sales. The system should facilitate lineup planning, manage artist contracts, and handle ticketing
logistics
Scenario 4: University Accommodation Service
Design a database system for a university's accommodation service that manages student
housing, room allocations, maintenance requests, and payments. The system should
accommodate different housing options and prioritize allocations based on specific criteria
Hi I have 17+ years of professional sql server development, mysql, postgresql development and performance tuning experience. Experience in python and machine learning. C# and PowerShell programing experience as well. I will be able to help you with the project. Please ping me offline to discuss further.
With an outstanding 17+ years career in database development, I bring a wealth of experience, technical proficiency and strategic insight to tackling your database design needs. As a leader with a background rich in cloud computing, data analytics and AI&ML among others like Quantum Computing, I have consistently catalyzed transformational endeavors and crafted inventive strategies across various industries.
I am not just limited to academic knowledge of normalizing your database design to 3NF alongside creating an attribute-filled & relationship-backed Entity-Relationship Diagram (ERD) using the right notation; I also have a proven track record for deploying advanced analytics solutions, employing data-building infrastructure with programming languages such as R, SAS and Python. Also being equally proficient with Database Management systems such as Oracle, Teradata and MongoDB among others makes me the complete package. With my ability to harmonize technology solutions with broader business objectives, I will ensure that your database provides a comprehensive solution that is both efficient and scalable – just what your library management scenario demands.
In addition to this strong data development background, I boast top-notch skills in KPI reporting, streamlined data processes optimization and statistical analysis among others which are imperative when developing efficient database systems.
Hi Dear ,
I am excited to submit a proposal for your database design project, focusing on one of the scenarios provided. After careful consideration, I believe Scenario 4: University Accommodation Service presents an intriguing opportunity to showcase our expertise in database design and implementation.
Here's how we plan to approach the project:
Entity-Relationship Diagram (ERD):
We will construct a comprehensive ERD that captures all essential entities, relationships, attributes, and primary keys. Using appropriate notation, we will clearly indicate relationships, cardinality, and participation constraints, ensuring a thorough representation of the university accommodation service.
Normalization:
Our team will apply normalization techniques, specifically aiming for at least 3NF (Third Normal Form). Through detailed explanation, we will demonstrate how we address redundancy and update anomalies, ensuring the database design is efficient and free of integrity issues. Any potential issues encountered during normalization will be identified and resolved effectively.
Thank you for considering our proposal. We look forward to the opportunity to collaborate with you on this project.
Best regards,
Ahmad taj
I have a lot of experience in database field and I currently work as a backend developer using MSSQL for a local company . I will provide a good service .
thank you
regards
I'm excited to offer my expertise in database development and ER diagram creation to support your projects. With a strong background in database management, I specialize in designing efficient and scalable database systems while creating clear and concise ER diagrams to visualize data models. I prioritize timely delivery and tailored solutions to meet your specific needs and budget. I'm eager to discuss how I can contribute to the success of your projects and provide you with top-notch database solutions. Looking forward to the opportunity to work together
"Delivering high-quality work as a freelance data entry specialist, content writer, and researcher. Proficient in Microsoft Office and Google Suite. Meeting deadlines with accuracy and efficiency. Available for new assignments and projects. Let's collaborate and achieve success!"