What are tow ways of creating database
Answers
Answered by
0
Programatically
The following is an example of creating a new table. Note that we are specifying the name of the table, the name of each column, and the data type of each column. More parameters can be added to this example if your requirements are more specific.
CREATE TABLE Albums (
AlbumId int,
AlbumName Varchar(255),
ReleaseDate dateTime,
ArtistId int,
Genre int)
Option 2: User Interface
Most graphical database management systems have a "Design View" (or similar) for creating tables. Design View enables you to create the names of each column, specify the type of data that can go into each column, as well as specifying any other restrictions you'd like to enforce.
Restricting the data type for each column is very important in relational databases, as it helps maintain data integrity. For example, it can prevent users from accidentally entering an email address into a field for storing the current date.
More properties can be added against each column if you require them. For example, you could specify a default value to be used (in case the field has been left blank by the user).
The following is an example of creating a new table. Note that we are specifying the name of the table, the name of each column, and the data type of each column. More parameters can be added to this example if your requirements are more specific.
CREATE TABLE Albums (
AlbumId int,
AlbumName Varchar(255),
ReleaseDate dateTime,
ArtistId int,
Genre int)
Option 2: User Interface
Most graphical database management systems have a "Design View" (or similar) for creating tables. Design View enables you to create the names of each column, specify the type of data that can go into each column, as well as specifying any other restrictions you'd like to enforce.
Restricting the data type for each column is very important in relational databases, as it helps maintain data integrity. For example, it can prevent users from accidentally entering an email address into a field for storing the current date.
More properties can be added against each column if you require them. For example, you could specify a default value to be used (in case the field has been left blank by the user).
Similar questions