RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Building Database
Database Tables
«Prev
Next»
SQL Database Creation
SQL - Server
Relational Database
Client Server Architecture
SQL Server Services
EM Administer SQL-Servers
Database Relational Concepts
SQL Server Tables
Data Integrity Elements
Business Rules
Database Normalization
Data Normalization
Database Denormalization
Primary Keys Unique Constraints
Foreign Keys
Relational Concepts
Column Attributes Table
Table Columns Types
Specifying Length Precision Scale
SQL Allow Null
Specify Default Column Values
Table Identity Columns
Rowguidcol Attribute Flag
Create Transact SQL Datatype
TableColumn Attributes Conclusion
SQL-Server DB Tables
Modify Database - Exercise
Create a database (course project, step 1)
Objective:
Create the course-project database.
Exercise Scoring
This exercise is worth a total of 10 points. You will receive up to five points for submitting the correct Transact-SQL syntax required to create the database, and up to five points for submitting the correct Transact-SQL syntax required to modify the database to allow for additional storage.
Instructions
This exercise begins your work on the course project, which, if you recall from the first module of this course, involves building a timesheet database that enables you to track your time and bill your supervisor or clients accurately. As a first step, you need to create the database and then modify the default size parameter to allocate additional disk space to it. Follow these instructions to ensure your success:
Write a Transact-SQL statement to create a database named "timesheet" with an initial database size of one megabyte and a transaction-log size of one megabyte. Use all the default file locations.
Write a Transact-SQL statement to increase the size of the database to 10 megabytes.
Submitting the exercise
Once you've entered your responses into the text boxes, click the OK, I'm Done button to submit the exercise to a tutor. Remember that you must submit all your responses to this exercise at once.