Profile cover photo
Profile photo
Saravanakumar Kandasamy
491 followers -
Asst. Professor in Information Technology
Asst. Professor in Information Technology

491 followers
About
Posts

Post has attachment
Find candidate key and normalize the relation into 2nf and 3nf
Find candidate key and normalize the relation into 2nf and 3nf Question: A relation R is defined as follows. R = (name, street, city, state, postal_code) Here, name is unique, and for any given postal code,
there is just one city and state. Give a set of
FD...
Add a comment...

Post has attachment
Relational model in DBMS Multiple choice questions with answers
Relational model in DBMS Multiple choice questions with answers Multiple Choice Questions 30: 1. Which one of the following is correct? a) Each candidate key is a primary key b) Each primary key is a foreign key c) Each foreign key must refer a primary key ...
Add a comment...

Post has attachment
Table creation in SQL solved exercise 1
Question: Write SQL queries to create tables
for company database as per the specification given below; [ Note: Primary keys are underlined. If not,
identify one. ] EMP( SSN , Name, Gender, Birthdate,
Street, City, DNO, SuperSSN, Salary) – stores informatio...
Add a comment...

Post has attachment
Lossless join decomposition one more example
Lossless Join Decomposition Question: Let R = {ssn, ename, pnumber, pname,
plocation, hours} and R is decomposed into three relations R1, R2, and R3 as
follows; R1 = EMP = {ssn, ename} R2 = PROJ = {pnumber, pname,
plocation} R3 = WORKS_ON = {ssn, pnumber,
h...
Add a comment...

Post has attachment
Generic steps involved in execution of an SQL Query
How an SQL Query is executed by
a Database Management System? Introduction: In this post,
I would like to discuss the Query Execution process in simple terms. The detailed
diagram of Query Execution process is given in Figure 1. I have mentioned two main
co...
Add a comment...

Post has attachment
ALTER TABLE statement in SQL
ALTER TABLE statement in SQL  ALTER TABLE statement ALTER TABLE is a Data Definition
Language (DDL) statement that alters the structure definition of an existing
database table. This statement can be used to alter the structure along with
the following comm...
Add a comment...

Post has attachment
CREATE TABLE statement in Oracle SQL with CHECK constraints
CREATE TABLE statement in Oracle SQL with CHECK constraints with CHECK constraint Syntax: CREATE TABLE < tablename> ( <column_name1> <datatype>, <column_name2> <datatype>, CHECK ( <column_name> in (
val1, val2, val3, …, valn) ) CHECK ( <column_name> between...
Add a comment...

Post has attachment
CREATE TABLE statement in Oracle SQL with constraint names
CREATE TABLE statement in Oracle SQL with constraint names With constraint name Syntax: CREATE TABLE <tablename1> ( <column name1> <datatype>, <column name2>
<datatype>, <conlumn name3>
<datatype>, CONSTRAINT < constraint name1
> PRIMARY KEY ( <column name1...
Add a comment...

Post has attachment
Create table statement in SQL simple explanation with examples
Create table statement in SQL simple explanation with examples CREATE TABLE statements CREATE TABLE - simple table creation CREATE TABLE - with constraints and without constraints name CREATE TABLE - constraints with constraint names CREATE TABLE - with CHE...
Add a comment...

Post has attachment
CREATE TABLE in Oracle SQL Simple version
CREATE TABLE in Oracle SQL Simple version Simple table creation in Oracle SQL [Note: in the syntax below, the
contents of angular brackets along with angular brackets to be replaced with
user defined words. Refer example below] Syntax: CREATE TABLE <tablena...
Add a comment...
Wait while more posts are being loaded