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?
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
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
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,