Cancelled

SQL Databases

Here are all the required details & attachments:

Important attachments for assignment.

- You must create the following script files in MSSMS; to do this select

Save from the File menu when you have finished typing the necessary code

and save it to disk. Script files should have a .SQL file extension.

Complete the following:

- Use the given initial ER diagram

- Create a script file that includes the code for creating the database

and all of the tables required in the project. PRIMARY KEY, FOREIGN KEY,

UNIQUE and CHECK constraints must be included. Make use of the IDENTITY

property, DEFAULT values and constraints. Remember that master/parent

tables must be created first.

- Create a script file to insert data into your user-created tables. Add

at least four records for each table without foreign keys and seven records

for each table that does contain a foreign key.

- Create a script file to create the views as specified.

- Create a script file to create the stored procedures as specified.

- Create a script file to create at least two triggers for your project.

There are no specifications for what types of triggers you must create. You

should apply your knowledge and create triggers that you think would be

appropriate.

- Create a script file to delete the database that you create.

- Create appropriate indexes on your tables.

- You should validate all applicable arguments in the stored procedures

where arguments are received.

- Make use of iteration where appropriate.

- Using the GUI (Graphical User Interface), create a full backup of your

database and send it to a zipped folder.

- Each script file must have a header section (using comments) that

contains the following information:

- Script file name

- Programmer name (add pseudo name)

- Date

- A short description of what the script file does

- When commenting your code, both styles of commenting (-- or /* */) may

be used. Just remember to maintain consistency throughout your project.

- Save all of the script files together with the backup onto a disk and

hand it in with printouts of the script files. Provide clear instructions

in your user documentation on how to execute the views and stored

procedures, including the arguments that need to be passed to the stored

procedures. In your user documentation you should include author and date

details, together with the purpose and description of the project.

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

Skills: SQL, MySQL, Database Programming, PHP, Microsoft SQL Server

See more: free online tuition sql databases, google maps sql databases, sql server 2005 project assignment, select file handlers unix, select file java applet, google map sql databases, ajax multi select file upload, shell script remove select file, perl select file upload, view image select file fileupload control aspnet, select file upload, ajax select file, vb6 code backup sql databases, ajax multiple select file uploader php, perl files select file directory, select file dialog java applet

About the Employer:
( 0 reviews ) islamabad, Pakistan

Project ID: #31922542

2 freelancers are bidding on average $120 for this job

(4 Reviews)
3.6
temaural

Hi, there I've been working for a database designer for 5 years I have been experienced realtional databases like mysql, oracle, mssql. I am the one who came up with the idea of MongoDB the document oriented database. More

$40 USD in 3 days
(3 Reviews)
2.9