Engineering

PRACTICAL 3 The bring to pass fudge Statement The lay down TABLE line is apply to create a immerge in a database. SQL CREATE TABLE Syntax CREATE TABLE table_name ( mainstay_name1 data_ suit, tower_name2 data_ image, column_name3 data_ emblem, .... )| The data type specifies what type of data the column can hold. For a masterful reference of all the data types available in MS Access, MySQL, and SQL Server, CREATE TABLE mannikin Now we compliments to create a table called Persons that contains quintette columns: P_Id, LastName, FirstName, come up to, and urban center. We lend oneself the following CREATE TABLE asseveration: CREATE TABLE Persons ( P_Idint, LastNamevarchar(255), FirstNamevarchar(255), Address varchar(255), City varchar(255) )| The P_Id column is of type int and will hold a derive. The LastName, FirstName, Address, and City columns atomic number 18 of type varchar with a maximum length of 255 characters. The expel Persons table will now look like this: P_Id| LastName| FirstName| Address| City|  |  |  |  |  | The empty table can be make full with data with the INSERT INTO statement. entropy types and ranges for Microsoft Access, MySQL and SQL Server. Microsoft Access Data Types Data type| Description| Storage| Text| mapping for textbook or combinations of text and song.

255 characters maximum|  | Memo| Memo is used for big amounts of text. Stores up to 65,536 characters. Note: You cannot sort a memo field. However, they be searchable|  | Byte| Allows hearty numbers from 0 to 255| 1 byte| hearty number| Allows whole numbers between -32,768! and 32,767| 2 bytes| Long| Allows whole numbers between -2,147,483,648 and 2,147,483,647| 4 bytes| Single| Single preciseness floating-point. impart handle most tenfolds| 4 bytes| simulacrum| Double precision floating-point. Will handle most decimals| 8 bytes| currentness| Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places. Tip: You can choose which countrys currency to use| 8...If you want to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper