Find Jobs
Hire Freelancers

Database II Mini Project - $$$

$10-30 USD

Completed
Posted almost 10 years ago

$10-30 USD

Paid on delivery
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?
Project ID: 5889078

About the project

9 proposals
Remote project
Active 10 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
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 in 2 days
5.0 (3 reviews)
4.5
4.5
9 freelancers are bidding on average $35 USD for this job
User Avatar
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 in 1 day
4.9 (13 reviews)
4.8
4.8
User Avatar
Hi, when is the deadline of your project? .
$50 USD in 10 days
5.0 (5 reviews)
3.3
3.3
User Avatar
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 in 1 day
5.0 (3 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
$54 USD in 10 days
4.9 (7 reviews)
3.1
3.1
User Avatar
Proposal belum diberikan
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This should be easy, please contact me trough pm so you can give a little more info.. .
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 14 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Guilderland, United States
5.0
4
Member since Dec 16, 2011

Client Verification

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)
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.