reset password
Author Message
Sanaz_6101
Posts: 40
Posted 16:21 Oct 18, 2009 |

should we create alter table as well as tales if so ,how can we create it?

im talking about Database Scripts part

Thanks

Last edited by Sanaz_6101 at 16:25 Oct 18, 2009.
cysun
Posts: 2935
Posted 16:26 Oct 18, 2009 |

I don't know what you mean.

Sanaz_6101
Posts: 40
Posted 16:37 Oct 18, 2009 |
cysun wrote:

I don't know what you mean.

this is refere to

[Database Scripts] (30pt)

Based on the csns.ddl file generated in the previous exercise, modify the following database scripts:

  • db/csns-create.sql - add the SQL statements to create the tables/constraints for the online assignments and submissions.
  • db/csns-drop.sql - add the SQL statements to drop the tables/constraints for the online assignments and submissions

at the end of my csns.ddl I have alter table with constraint shoud we create those in our sql-script ? I couldnt understand

cysun
Posts: 2935
Posted 16:39 Oct 18, 2009 |
Sanaz_6101 wrote:
cysun wrote:

I don't know what you mean.

this is refere to

[Database Scripts] (30pt)

Based on the csns.ddl file generated in the previous exercise, modify the following database scripts:

  • db/csns-create.sql - add the SQL statements to create the tables/constraints for the online assignments and submissions.
  • db/csns-drop.sql - add the SQL statements to drop the tables/constraints for the online assignments and submissions

at the end of my csns.ddl I have alter table with constraint shoud we create those in our sql-script ? I couldnt understand

Yes.