I need simple hosted sql database, PL-SQL Programming

Assignment Help:

Project Description:

I want a small relational database to be built. I want the database to have the subsequent information tables:

Employee Information

Document storage

Suppliers

Some form of project management (haven't thought about how this will work, concept's are welcome)

We sell tickets to events, so it could be good to be able to input sales into this for our financial records.

In terms of forms, some examples I'll need done are:

Add/Edit an employee

Upload document

Add/Edit suppliers

Add/Edit finance (incomings and outgoings)

I also want to be able to run reports (ie. Supplier/employee lists, finances between period X and Y etc).

I do not want data entry done, I'm happy to do this myself.

I'll also need:

A quick rundown on how to use it

Needs to be secure (plus I want the ability to grant access to particular users)

I want to be able to host this/upload this myself using an online host. I may need some basic instruction on how to upload this to and FTP server. I have web and IT experience, but no database experience.

I know for an experienced database engineer, this can be a simple task and probably only take a few hours.

Skills required are Database Administration, PHP, MySQL, Software Architecture, SQL


Related Discussions:- I need simple hosted sql database

Calculating a Shopper''s Total Spending, Many of the reports generated from...

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Delete statement - syntax, DELETE Statement The DELETE statement elimin...

DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Type versus representation confusion in sql, Type versus Representation Con...

Type versus Representation Confusion in SQL This describes how a value might have two or more distinct representations. For example, user-defined type POINT might have a decla

Parameter and keyword description - select into statement, Parameter and Ke...

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Exit-when - iterative control, EXIT-WHEN The EXIT-WHEN statement permits...

EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

Parameter aliasing, Parameter Aliasing   To optimize the subprogram ca...

Parameter Aliasing   To optimize the subprogram call, the PL/SQL compiler can decide between the two techniques of the parameter passing. With the by-value techniques, the v

Aggregate assignment-declarations in sql, Aggregate Assignment The %ROWT...

Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Example of groupby operator - sql, Example of GROUPBY Operator Example...

Example of GROUPBY Operator Example: How many students sat each exam, using GROUP BY, NATURAL LEFT JOIN, and COALESCE SELECT CourseId, COALESCE (n, 0) AS n FROM COURS

Keyword and parameter description in pl sql, Keyword and Parameter Descript...

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Compare sql and pl/sql, Question 1 . Compare SQL and PL/SQL Question 2 ...

Question 1 . Compare SQL and PL/SQL Question 2 . Write a database trigger to implement the following check condition                          Given the following table

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd