Create Database and Stored Procedures
$30-100 USD
货到付款
**Task 1 - Database Build**
There are 3 Excel workbooks in the zip file that detail the database structure.
1) Database Structure - [url removed, login to view]
2) Database Structure - Main [url removed, login to view]
3) Database Structure - Lookup [url removed, login to view]
Each table is a separate sheet in each workbook. There are 3 columns in each sheet:
**Table Name ??"** The name of the worksheet.
**Field Name** ??" The name of the field.
**Data Type** ??" The data type that should be used.
**Key** ??" Whether it is a primary or foreign key.
Create the tables with all of the structure detailed in the 3 Excel Workbooks.
**Task 2 ??" Stored Procedures**
For each table in the Database Structure - [url removed, login to view] you need to create 3 stored procedures (insert, update, delete). I have included an example database and stored procedures that detail exactly how to create the stored procedures. The naming of the stored procedures should follow this pattern.
For example:
For AUDIT_T’s stored procedures it should be:
p_del_ AUDIT_T
p_ins _AUDIT_T
p_upd_ AUDIT_T
**Task 3 ??" SQL Script**
I need an SQL script that creates the entire database including schema, database, tables and stored procedures.
**Notes:**
All Primary Keys should be AutoIncrement.
All tables and stored procedures should be in a schema called **MI_Audit**.
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
Microsft SQL Server 2005
项目ID： #3719899
关于项目
授予：
有18名威客正在参与此工作的竞标，均价$65/小时
