I have assignment in which i need to:
Create DataBase which has
Primary file of base DB_ASSIG1 (size 1GB, increase 100MB)
Secondary file of base DB_ASSEC1 (size 500MB, increase 50MB)
File group FG_ASSIG1 and in that group secondary file of base DB_ASSEC2
Transaction log file DB_log1
After creating base i need to create a table with structure like this:
Phone_ID, tip SMALLINT ,
Phone_Name, type VARCHAR(15) ,
Phone_Type, type VARCHAR (10)
Description, type VARCHAR(25) ,
Price, type SMALLMONEY ,
Manufacturer_ID, type integer
So im new into this and i dont even know how to begin this, if you can help me i would appreciate it. Thanks in advance.