Find Jobs
Hire Freelancers

Database II Mini Project - $$$

$10-30 USD

Concluído
Publicado há quase 10 anos

$10-30 USD

Pago na entrega
Create a proposal for building an information system for a business, organization, or a club. This information system will take the form of a database. Your proposal is designed to get approval to build your project. You may be making your proposal to a bank, a company president, the College President, the Mayor, or some other decision maker, depending on what you intend to do. Your application may be used to track records for any combination of people, equipment, sales, office, or job titles, or other attributes (with prior permission.) Think carefully about the following: Who is this application for? What problem are you trying to solve? What is the role of this application in solving that problem? (What will it accomplish?) Requirements Your database should have a minimum of 4 tables, 6 queries, and 2 stored procedures (or Triggers). You should have 2 or 3 tables, each representing a list of a real-world entity (people, things, places) and one or two tables to combine these (junction tables) SQL to generate a copy of the database A Create Table statement for each table used. INSERT statements for each record needed to populate the table. Queries At least 2 queries should contain multi-table joins. At least 2 queries should use a GROUP BY function. At least 2 queries should be an INSERT, UPDATE, or DELETE SQL statement (in a Stored Procedure or a trigger) The Stored Procedures should each contain a Transaction, and at least one INSERT, UPDATE, or DELETE SQL statement above. Note: SQLite doesn't support Stored Procedures, so just test an Insert, Update or Delete SQL statement Note: can skip triggers with SQLite - SQLite Browser doesn't support Trigger development well. Suggestions: ● A book publishing company ● An apartment building ● A summer camp ● Others ideas? (with permission) What to turn in: ● SQL code to generate database Queries, other code needed ● A 4 page Word document (1000 words) describing the project, containing at minimum: ■ What is the rationale for your project? ■ What tasks will your project accomplish? ■ Describe the data model – why did you choose the design you used? ■ What does each query accomplish? What does each stored procedure accomplish?
ID do Projeto: 5889078

Sobre o projeto

9 propostas
Projeto remoto
Ativo há 10 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi EnrichedGames I would like to work for your project . Please assign the project to me and will start work ASAP. also I have an experience You can also check the profile I have good review. Thanks, Bhavesh.
$30 USD em 2 dias
5,0 (3 avaliações)
4,5
4,5
9 freelancers estão ofertando em média $35 USD for esse trabalho
Avatar do Usuário
Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SEO / Content upload for eCommerce and Marketing. Understanding how valuable an education is, I am serving Pacific Pharmaceuticals Limited as a Asstt: Manager (MIS), toward earning my Masters of Business Administration (MBA) degree and B. Sc Computer Science. I have completed many web research/data entry/ General Admin and marketing project. I am 100% able to do your project. Sincerely, Tarikul Islam
$40 USD em 1 dia
4,9 (13 avaliações)
4,8
4,8
Avatar do Usuário
Hi, when is the deadline of your project? .
$50 USD em 10 dias
5,0 (5 avaliações)
3,3
3,3
Avatar do Usuário
HI.I BELIEVE I CAN DO THIS PROJECT FOR YOU. I HAVE A DIPLOMA IN DATABASE DESIGN ,SO I HAVE MUCH KNOWLEDGE OF DESIGNING RELATIONAL TABLES ,IN ADDITION TO NORMALISING TABLES. IN ADDITION I ALSO HOLD MICROSOFT CERTIFICATE IN SQL SERVER. SO THERE IS A VERY GOOD CHANGE THAT I WILL TAKE THIS PROJECT TO COMPLETION. THAT IS THE BACK-END OF YOUR SYSTEM. PLEASE GIVE ME A SHOUT I WILL BE ONLINE FOR A FEW,
$25 USD em 1 dia
5,0 (3 avaliações)
2,9
2,9
Avatar do Usuário
A proposal has not yet been provided
$54 USD em 10 dias
4,9 (7 avaliações)
3,1
3,1
Avatar do Usuário
Proposal belum diberikan
$25 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
This should be easy, please contact me trough pm so you can give a little more info.. .
$30 USD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$25 USD em 14 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Guilderland, United States
5,0
4
Membro desde dez. 16, 2011

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.