Мальчики, я пытаюсь поступить в асперантуру
Мне срочно нужно получить решение на два задания по SQL.
Умоляю вас, помогите пожалуйста, вышлите ответы мне на мыло avganca_w@mail.ru
В долгу не останусь!!!
ВОт задания:

Please write a pair of simplest SQL DDL (creation) scripts of 2 databases according to the following description (I need the general scripts. The ones may not work for MSSQL due to some syntax errors, but I want to see your ideas):

“There are 2 independent databases (D1, D2). Each database contains one stored procedure A, two views (B, C) and one table D. Objects from D1 are similar to the objects of D2 (the same objects with the little differences). Please create (write DDL scripts) the pairs of these objects if:

Stored Proc’s A use Tables D and Views C. These proc’s are different in a parameter set (parameters are used in the queries from D or C).
Tables D are different in primary keys (column names and column types within the tables have to be equal). Table D from D2 has one additional character field.
Views B use Tables D and Views C. These views are different in a column set
Views C use Tables D. These views are different in WHERE clause
First part: write DDL for all the objects for database D1 (in proper order of creating), then for D2. There must be no any cross-database references.

Example:

USE [D1]

GO



CREATE...

GO



CREATE...

GO

...



USE [D2]

GO



CREATE...

GO



CREATE..

...



Second part: write all the DDL operations (full SQL statements are preferred, but if you cannot list full DDL operations because of time limitation – list just the operation name with the shortest description, see the example) in proper order required for making database D2 to be equal with database D1 without errors (all changes are made to the database D2).



Example (if you cannot list exact SQL statements):

ALTER object xxx – this operation does …

DROP object xxx – this operation does …

…

You may use DROP, ALTER or CREATE statements where you want. Using of ALTER is preferred instead of object re-creation. Don’t care of data pre-serving.”