Assignment on SQL
Subject: Management | Topics:


SQL is a special-purpose programming language designed for managing data held in a relational database management system .

Create Table Construct

An SQL relation is defined using the create table command:

create table r (A1 D1, A2 D2, …, An Dn,

r is the name of the relation
each Ai is an attribute name in the schema of relation r
Di is the data type of attribute Ai

create table branch
(branch_name  char(15),
branch_city  char(30),
assets  integer)

Domain Types in SQL

char(n).  Fixed length character string, with user-specified length n.
varchar(n).  Variable length character strings, with user-specified maximum length n.
int.  Integer (a finite subset of the integers that is machine-dependent).
smallint.  Small integer (a machine-dependent subset of the integer domain type).
numeric(p,d).  Fixed point number, with user-specified precision of p digits, with n digits to the right of decimal point.
real, double precision.  Floating point and double-precision floating point numbers, with machine-dependent precision.
float(n).  Floating point number, with user-specified precision of at least n digits.
More are covered in Chapter 4.
Integrity Constraints on Tables
not null
primary key (A1, …, An )

Example:  Declare branch_name as the primary key for branch.

create table branch
(branch_name  char(15),
branch_city  char(30) not null,
assets  integer,
primary key (branch_name))


Related Management Paper:

Popular Management Paper:

Basic Concepts of TQM

Total Quality Management (TQM) is an enhancement to the traditional way of doing business. It is a proven technique to guarantee survival in world‑class competition. Only by changing the actions of management will the culture and actions of an entire organization be transformed. TQM is for the .....

Assignment on Conflict Management With real life Example

What is Conflict? We define conflict as a disagreement through which the parties involved perceive a threat to their needs, interests or concerns. It’s human nature to have conflicts and it arises for any number of reasons, including: Misunderstandings Personality clashes Disagreements about th.....

Recruitment and Selection Process in Nestle Bangladesh Ltd.

INTRODUCTION 1.1: Background of the Report An employee might more knowledgeable and skilful by training and development program or process that maintaining an effective level job performance. So it acts an important role in HR department. As a part of BBA program, our Human Resources practices in.....

Report on Janata Bank Limited

1.1 Introduction of the Study The primary purpose of this report is to get an idea about the operations of Janata Bank Limited, a second-generation bank of the country and make an industry analysis on the banking sector of Bangladesh. Banks are profit – earning concern. The ‘word “Bank.....

Contemporary Issues of Cost and Management Accounting in Bangladesh

Abstract Cost and Management Accounting practice helps an organization to survive in the competitive, ever-changing world, because it provides an important competitive advantage for an organization that guides managerial action, motivates behaviors, supports and creates the cultural values necess.....