
To describe the process of creating a table in SQL and a list of different data types used for fields.

Explanation of Solution
In SQL CREATE TABLE command is used for making the table, and to describe its layout.
The syntax for creating the table:
CREATE TABLE table_name (column1 datatype, …., column n datatype);
For example, following command will create an employee table with two fields EmployeeID and EmployeeName.
CREATE TABLE Employee (EmployeeId int, EmployeeName varchar (10));
Rules for naming tables and columns in SQL vary slightly from one version of SQL to another version. Some common rules for naming tables and columns in DBMS are as follows:
• The names should not contain more than18 characters.
• Names must start with a letter.
• Names can only contain letters, numbers, and underscores ().
• it does not contain spaces.
List of data types used for field:
- Integer: it stores an integer, i.e., the number without decimal part. The valid data range for integer is −2147483648 to 2147483647. There is no need to specify the length of an integer.
- Smallint: it Stores integers but it, uses less storage space than the integer data type. The valid data range is −32768 to 32767. Sometimes, smallint is a better choice than integer when we have a certain field that will store numbers within the indicated range.
- Decimal (a, b): It stores a decimal number having a number of places before decimal and bnumber of places after decimal. For example, decimal (6,2) represents a six-digit number with three places to the left and two places to the right of the decimal. Most commonly, decimals, are used to represent either the currency or the number data type.
- Char(n): it Stores a character string, which is n characters long. The value for n must be an integer.
- Date: it Stores dates in the form DD-MON-YYYY or MM/DD/YYYY. For example, May 12, 2019, could be stored as 12-MAY-2019 or 5/12/2019.
Want to see more full solutions like this?
Chapter 3 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
- show all the workarrow_forwardList down the strenghts and weaknesses of your team project for Capsim Simulation? Explan.arrow_forwardCapsim Team PowerPoint Presentations - Slide Title: Key LearningsWhat were the key learnings that you discovered as a team through your Capsim simulation?arrow_forward
- Write the SQL code that permits to implement the tables: Student and Transcript. NB: Add the constraints on the attributes – keys and other.arrow_forwardDraw an ERD that will involve the entity types: Professor, Student, Department and Course. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.arrow_forwardDraw an ERD that represents a book in a library system. Be sure to add relationship types, key attributes, attributes and multiplicity on the ERD.arrow_forward
- 2:21 m Ο 21% AlmaNet WE ARE HIRING Experienced Freshers Salesforce Platform Developer APPLY NOW SEND YOUR CV: Email: hr.almanet@gmail.com Contact: +91 6264643660 Visit: www.almanet.in Locations: India, USA, UK, Vietnam (Remote & Hybrid Options Available)arrow_forwardProvide a detailed explanation of the architecture on the diagramarrow_forwardhello please explain the architecture in the diagram below. thanks youarrow_forward
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning




