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

Keyword and parameter description - forall statement, Keyword &Parameter De...

Keyword &Parameter Description: index_name: This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript

Autonomous versus nested transactions, Autonomous versus Nested Transaction...

Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)

Sql operators, SQL Operators The PL/SQL uses all the SQL set, compariso...

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Parameter and keyword description - %type attribute, Parameter and Keyword ...

Parameter and Keyword Description: collection_name: This keyword identifies the index-by table, nested table, or varray formerly declared within the present scope. cu

Data types in sql - character, Data Types in SQL - Character CHARACTER...

Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

What is a record, What Is a Record  ? A record is a group of related...

What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

Structure of an object type in pl/sql, Structure of an Object Type: Si...

Structure of an Object Type: Similar to package, an object type has 2 parts: the specification and the body. The specification is the interface to your applications; it declar

%rowtype - cursors, %ROWTYPE: This attribute gives a record type which ...

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

Best practices/Data Warhousing, What are 3 good practices of modeling and/o...

What are 3 good practices of modeling and/or implementing data warehouses?

%found - implicit cursor attributes, %FOUND Until the SQL data manipul...

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

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