SQLTeam.com | Weblogs | Forums

Sql task

Can you help me with the task in sql?

Possibly someone on the forum could help you with your task. But, unlike a live chat forum, it would be inefficient to have a two-way conversation (which would necessarily be non-real time) on this forum. So you should describe the problem that you want to solve, in detail, with code to generate sample data.

Can you help me?
I need to create a pot database that has:
-primary database file DB_ASSIG1 (size 1GB, increase 100MB) ;
-secondary database file DB_ASSEC1 (size 500MB, increase 50MB) ;
-file group FG_ASSIG1 and in it a secondary database file DB_ASSEC2 ;
-transaction log DB_log1.

After creating the database, create a table with the following structure in the database:

  • Phone_ID, tip SMALLINT ;
  • Phone_Name, tip VARCHAR(15) ;
  • Phone_Type, tip VARCHAR (10) ;
  • Description, tip VARCHAR(25) ;
  • Price, tip SMALLMONEY ;
  • Manufacturer_ID, tip integer.

After creating the database, subsequently add a new Design_ID column, of type integer, that will not have a NULL value. Create screen shot created bases and tables.

Thanks in advance.

Rose, please don't double-post. You stated in your other post that SQL wasn't working for you. Not sure what that means, but this sounds like homework. At least give it a try and post what you tried.