Find Jobs
Hire Freelancers

Model, design and implement a relational database with a web-based interface for a specific given case study

£20-250 GBP

Cerrado
Publicado hace más de 7 años

£20-250 GBP

Pagado a la entrega
1. Produce an Entity-Relationship Model Develop a top-down design of the data in the form of an entity-relationship diagram. You should note all assumptions you make about the data and the reasoning behind your design choices. Also include any appropriate constraints and a list of entity types showing their attributes and identifiers. 2. Design a set of relations conforming to Boyce-Codd Normal Form (BCNF). Once you are satisfied that the ER diagram is a good representation of the data, produce a logical design by mapping the E-R diagram to a set of (normalized) relations. Clearly show all intermediate steps. 3. Implement your final database design. Take each of the relations from your relational model and implement them as SQL tables. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate. Then, using appropriate sample data and your own imagination, populate your finished tables. 4. Query your database. Using SQL, write a set of realistic sample queries based on the above scenario (use your imagination for details of each query) but they should include the following SQL query techniques: • Joins (using two, three or more tables) • Set operations (UNION, INTERSECT and MINUS) • Ordering • Grouping • Aggregate functions (MIN, MAX, AVG, COUNT, SUM) • Table aliases • Renaming columns • Sub-queries (nested queries) You should aim to write at least ten sample queries – ranging from basic SELECT…FROM…WHERE queries to more advanced ones using the above techniques. 5. Optimize your Database You should now optimize your database: • Apply suitable database optimization techniques to your final set of tables. • Aim to implement a range of indexes. • Run a suite of queries that will invoke those indexes. • Aim to demonstrate some index suppression techniques. 6. Secure your Database Your optimized database should now be secured. To demonstrate this: • Create three new users on your database • Allocate them different security privileges and roles. • Create a suite of views over your existing base tables. • Issue appropriate privileges so that at least one user can use those views. • Clearly demonstrate what actions each user can/cannot perform. 7. Building a Web Interface You now have a fully working, secure and optimized database. design and build a web-based interface to that database such that it can support the following operations: • Insert new rows of data • Update existing rows of data • Delete existing rows of data • Query existing rows of data
ID del proyecto: 11943705

Información sobre el proyecto

15 propuestas
Proyecto remoto
Activo hace 7 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
15 freelancers están ofertando un promedio de £177 GBP por este trabajo
Avatar del usuario
I am a professional full time academic research writer fully proficient in HARVARD, APA, MLA, Chicago and Oxford writing styles. I am competent in writing dissertations, thesis, reports, case studies, personal development plans, personal statements, marketing plans, comparative studies (companies/countries), review of literature and systemic literature review. I am able to carry out research utilizing mixed method, qualitative or quantitative research. My services range from undergraduate to Ph.D. academic level and I have written papers on management (organizational/business management including but not limited to Organizational/Business strategy, Strategic analysis etc.), HRM (Strategic HRM, IHRM etc.), Operations management, Marketing (plans, positioning etc.), Chemistry, Nursing, Psychology, Political Science, History, Geography, World Affairs and Religion. My work is tailor-made to suit my client's needs and is written from an analytical and critical perspective utilizing up to date peer-reviewed sources of academic literature and books.
£500 GBP en 3 días
4,8 (613 comentarios)
8,0
8,0
Avatar del usuario
Hello, how are you? I hope you have a bright day/evening from your side. I have read the details provided, but please contact me so that we can discuss more on the project. I believe I have the required skills in this case. I will work on your requirements personally since I do not outsource to third parties, this guarantees you high-quality work that is delivered on time. You can also request for revisions till you’re fully satisfied with the work. I believe writing is a passion and not a money making business where people will deliver low-quality work just to get paid. Try my services, and you will never regret. Waiting for your kind response
£105 GBP en 3 días
4,7 (144 comentarios)
6,6
6,6
Avatar del usuario
I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server 2008 and Oracle10g. I can Develop you ER Diagrams (Crows foot notation), EERD, I can convert them to Rational DB, I can do its Normalization up to 3rd Normal form. I can show you my previous work related to DB. Please see my profile and reviews as well. Thanks
£150 GBP en 4 días
4,9 (113 comentarios)
6,5
6,5
Avatar del usuario
Hi, I have been working as Web Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html https://www.freelancer.com/projects/database-administration/Database-Coursework.html I'm assuring you that you will score more than 90% I'm looking forward to hearing from you very soon
£100 GBP en 3 días
4,5 (65 comentarios)
5,9
5,9
Avatar del usuario
Hire my academic writing services for: • Thesis • Dissertations • Personal Statements • Speech Writings • Research papers • Case studies • Essays • Literature reviews • Proposals • Annotated Bibliography And the like…. I am PhD in English, with advance experience in teaching students of different standards. You can count on my qualitative as well as quantitative research and academic writing abilities. Being an expert writer, equipped with an experience of more than 7 years in writing academic content using MLA, APA, CHICAGO, HARVARD, AND IEEE styles in particular, I can assist you in all types of academic writing tasks. Send me the order details and I will be on it accordingly. Thanks and awaiting your response. Robert
£200 GBP en 4 días
4,7 (44 comentarios)
5,2
5,2
Avatar del usuario
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Microsoft SQL, Access and etc. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Some reference projects: a) Responsive website on .NET - https://www.freelancer.com/projects/C-Sharp-Programming-ASP-NET/ASP-Net-Responsive-Web-Application/ --> Review -> “Thanks Hardik! Great work.” b) VB 2013 Desktop Application with AWS integration -https://www.freelancer.com/projects/Amazon-Web-Services-Windows/Visual-Basic-Express-Desktop-Application/ --> Review--> "Great Job! Would hire again!" c) Data pull application from Facebook using VB.NET -https://www.freelancer.com/projects/PHP-Social-Networking/Timeline-Posts-Extraction-with-Likes/ --> Feedback by Client --> "I was extremely satisfied by hardikshah83's work. Excellent communication skills. Very professional. I asked for a couple of changes in the course of the project and he delivered them gracefully." Let's discuss and make this project a success. This is a tentative bid, and may change post understanding exact scope.
£150 GBP en 3 días
4,8 (10 comentarios)
4,3
4,3
Avatar del usuario
i am sql expert and can make entinity or erp diagrams as u mentioned in the project, waiting for your reply so we can go ahead
£200 GBP en 2 días
5,0 (12 comentarios)
3,9
3,9
Avatar del usuario
Personally I am computer major. I believe in offering top-notch, original academic assistance at reasonable rates to my clients. I offer high quality papers and ensure a timely delivery. I am optimistic, mature, friendly, and innovative. Besides that, I am able to learn new concepts quickly after little orientation and a brief period of adjustment to the learning curve. My freelancing approach is to put the interests of all my clients first with an aim of developing a good rapport. I always put the value invested in me through efficient output to ensure 100% client satisfaction. Hire me for an outstanding and excellent work. I am ready to make you ace your project.
£200 GBP en 5 días
4,6 (6 comentarios)
2,9
2,9
Avatar del usuario
I am conversant with the topic and the order instructions. I promise that I will deliver a plagiarism-free and high-quality paper within the given time.
£150 GBP en 3 días
3,4 (1 comentario)
0,7
0,7
Avatar del usuario
HI I have read out all the description given in your project. I am fully capable to complete this project with 100% accuracy and as per your requirement. I have completed many assignments (Research Papers, Dissertation, Essays, Business Plans, Reports, Book writing & other assignments) in the past similar to this for different Colleges, Universities Students in USA, U.K and Australia. I am also familiar with every kind of writing style e.g. MLA, APA and Harvard etc. Please share with me the remaining details if you have any and pay me after checking the work. Regards
£150 GBP en 3 días
5,0 (2 comentarios)
0,0
0,0
Avatar del usuario
Greetings - I am a professional Software Developer with over 6 years of working experience with SQL, and 2 years as a Web Developer (PHP, Perl, Ruby on Rails, in a Linux environment). In addition to this, I have B.S. in Computer Engineering and have performed tasks similar to what you are asking. While I will need to verify what your data is, as asked in bullet point 1, and I will need to ask you some clarifying questions (i.e. are there any restrictions on the type of Web Front end?), I believe this task is well within my capabilities.
£250 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
london, United Kingdom
5,0
2
Forma de pago verificada
Miembro desde oct 10, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.