Walk-in for .Net Developer 2-6 years Experience at Freyr software services‏

Walk In Interviews on 1st August 2014 Friday for (2-6) years' experience .Net developer

Work Location: Hyderabad

Interview date: 1st August 2014 Friday

Time: 10:30 A.M to 3:30 P.M.

Eligibility Criteria:-
Qualification: Any BE / B.Tech/Mtech

Interview Venue Details:
Freyr solutions, Global Operations Center ,
Lanco Hills Technology Park,99LH 2nd floor,
Incubation Center,
Manikonda, Hyderabad - 500089,
India, Phone: +91 40 4848 0999 

Job Description:
*Good knowledge of visual studio 2008, 2010 using programming language C#.
*Should have good knowledge of:
*WindowsXP/2008/Windows 7.0
*XML (both data-focused and application configuration uses)
*Database platforms (MS SQL Server 2005, 2008)

Essential Skills:
*Strong ASP.Net with C# Exp
*Javascript
*JQuery
*AJAX
*WCF

Thanks
GVK Online Trainings-ADMIN TEAM 

MSBI Course Content

Hi  Team,

Please find the course content for MSBI (SSIS/SSAS/SSRS).

CLICK HERE

Duration: 45 Days
Daily: 1.30  Hr

Thanks
GPK

Excellent Opportunity for Oracle D2K or Pl/sql Professional for 1 - 3 years at Chain-Sys

Chain-Sys:

Chain-Sys is the fast growing Business Consulting and Product Development company with key expertise in Business Process Automation - Solutions. Our Operations launched in the year 1998 at Lansing, Michigan USA, supported by our Global Development Center in Chennai, INDIA. Our Global Business Operations is spread across UK, Singapore & US and National Operations across major metros like Chennai, Bangalore, Coimbatore, Mumbai & Delhi.


Candidate Profile:
* Min 1 + years of experience in any of the programming languages like PL/SQL,
forms & reports, D2k.
* Good in communication & interpersonal skills.
* Adaptable, learning nature.
* Should be willing to work in different project locations.

Job Description:
* Will be trained in development and customization of Oracle ERP.
* Will be trained in the implementation of Oracle ERP (R12 - E-business suite).

Pre-requisites:
* Minimum of 1 to 3 years exp
* Good communication skill
Location: Chennai

Interested candidates pls mail your Cv to sathish.ms@chain-sys.com with the below mentioned details asap
Name:
Exp:
Curr ctc:
Expected ctc:
Notice period:

Thanks
GVK Online Trainings- ADMIN TEAM

Urgent Requirement for Dot Net (0-1yrs) in HYD

Job Description

1. A Strong candidate with knowledge on ASP.NET ,C#, Javascript, AJAX, Web services, WCF .
2. Excellent problem solving skills with Datastructures and Algos
3. Strong diagnostic & troubleshooting skills
4. Knowledge of working with CSS Styles.

5.Excellent Communication skills required.

Qualification

• BE/BTech/ME/MTech/MCA or any relevant degree.

Experiance : Fresher

CTC: Negotiable

Location:Hyderabad

Joining Period - 30 to 45 days

 Min Experience: 0 Yr  Max Experience: 1 Yr

Location: Hyderabad

Max Salary: Rs 2.5 Lakh / Yr

 Drop Resumes at jobs@techringers.in

Thanks
GVK Online Trainings-ADMIN TEAM

Tera Data Openings at Value Labs for exp3-6 years

Thanks
GVK Online Trainings-Admin Team

Fresher job Openings for 2014 Btech passed outs

Thanks
GVK Online trainings ADMIN TEAM

New MSBI batch starts from 23rd July2014

Hello Team,

We are going to start new MSBI start from 23rd July please find the below details.

Timings: 4.30-5.30AM ISD

Prerequitites :SQL Server 2012/2008R2/2008[tsql+tsql programming]

Module going to start:MSBI[SSAS]

For any queries contact us at gvkoltrainings@outlook.com

Thanks
GVKOnlineTrainings-Admin Team

UPDATE Command in SQL SERVER 2012

UPDATE:

It is used to modify the contents in the table,It is used to work with rows or records in the table.

We can update single column data or multiple columns data.Specific data  can be updated based on some condition,this condition is specified using where clause.

Syntax:

UPDATE <TABLE_NAME>
SET <COLUMN_NAME>=<EXPR/VALUE>
[WHERE CLAUSE]
SELECT * FROM EMP20

UPDATE EMP20
SET JOB='ANALYST' --will update the column job with 'ANALYST

SELECT * FROM EMP20

UPDATE EMP20
SET JOB='MANAGER'
WHERE ENO=1004 --Will update the job of employee whose number is 1004 with 'MANAGER'

SELECT * FROM EMP20

UPDATE EMP20
SET JOB='SALESMANAGER'
WHERE ENAME='VINAY' --Will update the job of employee whose name is 'VINAY' with 'MANAGER'

UPDATE EMP20
SET JOB='PROGRAMMERS'
WHERE JOB='ANALYST'--Will update the job of employee whose job is 'ANALYST' with
'PROGRAMMERS'

SELECT * FROM EMP20

Example2
CREATE TABLE STUDENT
(
SNO INT,
SNAME VARCHAR(15),
MAT INT,
PHYS INT,
CHEM INT,
TOTAL INT,
AVEG DECIMAL(4,2)
)
SELECT * FROM STUDENT

INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(101,'VINAY',50,70,80)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(102,'ANIL',60,90,72)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(103,'PAVAN',58,71,86)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(104,'SURESH',90,82,66)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(105,'RAMESH',85,77,73)

UPDATE STUDENT
SET TOTAL=MAT+PHYS+CHEM,
AVEG=(MAT+PHYS+CHEM)/3--'Here we are going to update the AVEG column by evaluating the expression with the help of MAT/PHY and CHEM columns.

UPDATE STUDENT
SET MAT=70
WHERE SNAME='VINAY'--'we are updating the maths marks of a student whose name is 'VINAY'
UPDATE STUDENT
SET SNAME='RAJESH'
WHERE SNO=105--'we are updating the name of a student whose student id 105

SELECT * FROM STUDENT

 **If we don't use where clause in UPDATE Command the update will reflect to all the table based on set clause.

Thanks
GSV

Identity in SQL SERVER 2012

IDENTITY:
It is used to generate unique values in sequential order.it can be called as autonumber.

If we use identity to a column there is no need of inserting values into that column. 
Syntax:

IDENTITY(<INITIAL_VALUE>/SEED,<INCREMENT>)

Example:

CREATE TABLE EMP1
(
ENO INT IDENTITY(1000,10),
ENAME VARCHAR(15)
)
Here we are specifying that eno is automatically generated when ever there is an insert is performed the eno starts with 1000 and increments with 10
INSERT INTO EMP1(ENAME) VALUES('RAMU')

SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('SRINIVAS')
INSERT INTO EMP1(ENAME) VALUES('ASHOK')
INSERT INTO EMP1(ENAME) VALUES('SURESH')

INSERT INTO EMP1(ENAME) VALUES('RAMESH')
INSERT INTO EMP1(ENAME) VALUES('RAHUL')

SELECT * FROM EMP1

DELETE FROM EMP1
WHERE ENO=1050

SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('RAHUL')

SELECT * FROM EMP1

DELETE FROM EMP1
Here we deleted all the records from emp1 table,but identity will not be reset .

SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('RAHUL')

TRUNCATE TABLE EMP1
if we use truncate identity will be reset.
SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('RAHUL')

This insert will start with seed
We can also use command to reset the identity instead of using truncate but best approach is we can reset using truncate.

Synatx:

DBCC CHECKIDENT('<TABLE_NAME>',RESEED,<INITIAL_VALUE>)

EXAMPLE:

DBCC CHECKIDENT('EMP1',RESEED,1000)

Database console check point by using this we can able to reset

INSERT INTO EMP1(ENAME) VALUES('SRINIVAS')
INSERT INTO EMP1(ENAME) VALUES('ASHOK')
INSERT INTO EMP1(ENAME) VALUES('SURESH')

INSERT INTO EMP1(ENAME) VALUES('RAMESH')

SELECT * FROM EMP1

Thanks
GSV

TRUNCATE in SQL SERVER 2012

TRUNCATE:

It is used to delete all the records from the table without deleting the table structure.

It clears the auto generated numbers also where delete will delete all or few records without clearing the auto generation of numbers.
Syntax for truncate:

TRUNCATE TABLE  <TABLE_NAME>

example:

truncate table emp20--It will delete all the rows from the table,we can't use where clause.

select * from emp20-herew e wont get any data.

we will see more about auto numbers in next article.

Thanks
GSV

DELETE Command in SQL SERVER 2012

DELETE :

Delete command is used to delete the rows from a table,we can delete specific rows by using where clause.

Without where clause delete command will delete all rows without disturbing the table structure.

Syntax for delete command  :

DELETE [TOP(N)] [FROM]  <TABLE_NAME>
 
[WHERE <CLAUSE>]

Examples:

SELECT * FROM EMP20

DELETE FROM EMP20

it will delete all the employees from the table.

SELECT * FROM EMP20 --will get empty table

DROP TABLE EMP20--going to drop a table
 
It will drop the table permanently.

SELECT * INTO EMP20 FROM EMP--creating a table again and dumping the rows into new table.

SELECT * FROM EMP20

Now the table contains all the records.

DELETE FROM EMP20
WHERE ENO=1001
 
we are going to drop a record with eno equal to 1001

SELECT * FROM EMP20

DELETE FROM EMP20
WHERE ENAME='RAMESH'

we are going to drop a record with ename equal to 'RAMESH'

SELECT * FROM EMP20

DELETE FROM EMP20
WHERE JOB='CLERK'

we are going to drop a record with JOB equal to 'CLERK'

DELETE TOP(20) FROM EMP20-- will delete top 20 records from the table.

SELECT * FROM EMP20

DELETE TOP(2) FROM EMP20--will drop top 2records from the table.

SELECT * FROM EMP20

Thanks
GSV

ALTER Command in SQL SERVER 2012

ALTER: It is used to modify the definition or the structure of the table or definition of the database object.

Syntax:

ALTER TABLE <TABLE_NAME>
[ADD <COLUMN_NAME> DATATYPE[SIZE]]
[ALTER <COLUMN_NAME> DATATYPE[SIZE]]
[DROP COLUMN <COLUMN_NAME>]
[ADD CONSTRAINT <CONSTRAINT_NAME> (COLUMN_NAME)]
[DROP CONSTRAINT <CONSTRAINT>]

1.TO ADD A NEW COLUMN into existing table:

Example:

ALTER TABLE EMP20
ADD TOTALSAL INT

new row is added to the table emp20

Whenever we created a new column it always come at the end of the table, we can't place at beginning or at middle of the table.

SELECT * FROM EMP20

ALTER TABLE EMP20
ADD email_id varchar(15)

new row is added to the table emp20

SELECT * FROM EMP20

Can we add multiple columns to existing table ?

yes, we can by separating comma for column name and data type value pairs as shown below.

ALTER TABLE EMP20
ADD email_id varchar(15),TOTALSAL INT

SELECT * FROM EMP20

2.To modify the data type or size of the existing column
ALTER TABLE EMP20
ALTER COLUMN EMAIL_ID VARCHAR(20)

size of the column capacity got changed with the above query.

ALTER TABLE EMP20
ALTER COLUMN EMAIL_ID INT

the data type of column email_id converted from varchar to int
sp_help emp20

ALTER TABLE EMP20
ALTER COLUMN EMAIL_ID SMALLINT

the data type of column email_id converted from int to smallint
sp_help emp20

3.TO DROP A COLUMN from existing table:
ALTER TABLE EMP20
DROP COLUMN EMAIL_ID

column email_id got dropped

 SELECT * FROM EMP20

ALTER TABLE EMP20
DROP COLUMN TOTALSAL

column TOTALSAL got dropped

SELECT * FROM EMP20

 Can we Drop multiple columns from existing table ?

yes we can as shown below

ALTER TABLE EMP20
DROP COLUMN TOTALSAL,COLUMN EMAIL_ID

SELECT * FROM EMP20

4.How to change the column name of a table ?  
syntax:

SP_RENAME '<TABLE_NAME>.<COLUMN_NAME>','<NEW_COLUMN_NAME>'

SP_RENAME 'EMP20.SAL', 'SALARY'

we will saw how to work with constraints with alter in soon.

Thanks
GSV

Opening with ITC Infotech for the position of MSBI Developer-Kolkata‏

Experience required for the Job: 1 - 3 years

Job Location: Kolkata

Opening with ITC Infotech for the position of MSBI Developer-Kolkata

Job Description

1) 1 to 3 years of support and / or development experience in SQL 2008/2012
2) Good knowledge in SQL Query and Stored Procedure for enterprise level applications
3) Good working knowledge in MS excel
4) Working knowledge in SQL Server Database 2008, SQL Server BI Suite 2008 -specially SSIS & SSRS Package development,configuration and operation will be given preference
5) Good communication skills - both written and oral

Interested candidate should send the resume @ rupsa.das@itcinfotech.com, also mention the following details

Current CTC :

Expected CTC :

Notice Period :

DOB :

Education.:

Contact details : rupsa.das@itcinfotech.com

Thanks

GVK ONLINE TRAININGS-ADMIN

Select Command in SQL SERVER 2012

DQL (Data Query Language)/DRL (Data Retrieval Language) has one command "SELECT" which is used to display a set of rows from one table/more than one table.

We can use SELECT command by using different options as shown below:

1.Version1 of select:
syntax:

SELECT * FROM <TABLE_NAME>

Example:

SELECT * FROM EMPLOYEE

By using the above syntax and example we can able to get all the columns in a table and and all the rows from table.

2.Version2 of Select:

syntax:

SELECT <COLUMNS_LIST> FROM <TABLE_NAME>

Examples:

1.SELECT ENAME FROM EMPLOYEE

2.SELECT ENAME,SAL FROM EMPLOYEE

3.SELECT EID,SAL FROM EMPLOYEE

4.SELECT EID,ENAME,SAL FROM EMPLOYEE

all the above are valid.

By using the above syntax or examples we can able to get specific columns from a table/more than one table with all the row values of a specific columns.

3.Version3 of Select:

syntax:

SELECT <COLUMNS_LIST>/ * FROM <TABLE_NAME>

WHERE <CONDITION>

Examples:

1.SELECT * FROM  EMPLOYEE
   WHERE EID=1000

2.SELECT * FROM  EMPLOYEE
   WHERE EID=1001

3.SELECT * FROM  EMPLOYEE
   WHERE ENAME='srinivas'

4.SELECT ENAME FROM  EMPLOYEE
   WHERE EID=1000

5.SELECT ENAME FROM  EMPLOYEE
   WHERE EID=1001

6.SELECT SAL FROM  EMPLOYEE
   WHERE EID=1002

By using the above syntax or examples we can able to get all the columns /few columns from table or from more than one table (using joins) but we can only the rows which are satisfied by the where clause.

4.Version 4 of Select:

syntax:

 SELECT <COLUMNS_LIST>/ * FROM <TABLE_NAME>
[WHERE <CONDITION>]
ORDER BY <COLUMN_NAME> [DESC]  

Examples:

1.SELECT * FROM EMP

   ORDER BY SAL

2.SELECT * FROM EMP

   ORDER BY SAL DESC,ENAME

3.SELECT * FROM EMP

   ORDER BY ENAME

4.SELECT * FROM EMP

   ORDER BY ENAME DESC

5.SELECT * FROM EMP

   WHERE JOB='CLERK'

   ORDER BY SAL DESC

6.SELECT * FROM EMP

   ORDER BY JOB,ENAME

7.SELECT * FROM EMP

   ORDER BY JOB,ENAME DESC

8.SELECT * FROM EMP

   WHERE DEPTNO=10

   ORDER BY SAL DESC

ORDER By clause is used to sort any one or more columns of a result set in ascending or descending order by default  ascending order will come. 

NOTE:if we specify two column names in order by clause the first column will come in ascending or descending order for the column if any equal values came more than once for them second column will perform sorting and give the order.

5.Version 5 of Select:

Syntax:

SELECT TOP N <COLUMNS_LIST>/ * FROM <TABLE_NAME>
[WHERE CLAUSE ]
[ORDER BY ]

it will return top n rows from result set

Examples:

1.SELECT TOP 2 * FROM EMP

2.SELECT TOP 3 * FROM EMP
ORDER BY SAL DESC

3.SELECT TOP 3 * FROM EMP
ORDER BY SAL

top clause is the last one which will execute along with the query once after all the clauses are executed and result set is prepared then top clause will be applied on result set and that will come as final result set.

watch this space for more versions of SELECT command and let me know if you have any doubts

Thanks

GSV

DROP Command in SQL SERVER 2012

Drop command is used to delete the Database or DataBaseObject  (table,view,
function,indexes,procedures,triggers etc) from Sql Server permanently.

1.DROPPING A DATABASE

Syntax:

DROP DATABASE <DATABASE_NAME>

Example:

DROP DATABASE SRINIVASS

2.DROPPING A TABLE FROM DATABASE

Syntax:

DROP TABLE <TABLE_NAME>
example:

DROP TABLE EMPLOYEE

We can able to drop more than one table at a time also by separating comma

DROP TABLE EMPLOYEE1,EMPLOYEE2

we will see more examples in near future...

Thanks
GSV

Create Command in SQL server 2012

CREATE keyword is used to create database objects like databases,Tables,Stored Procedures,functions,views,indexes,triggers etc  

1.Syntax to create Database:  

1.  CREATE DATABASE <database_name> 

if we use this syntax we will automatically get primary and log files with default options

example:

create database srinivas                                                                      

               (or)

2. CREATE DATABASE <database_name>
   on
(
Name=Logical_name,
filename=path&fileName,
size=<size>,
maxsize=<size>,
FileGrowth=<size>)
log on
(
Name=Logical_name,
filename=path&fileName,
size=<size>,
maxsize=<size>,
FileGrowth=<size>
)

for the above syntax we can able to specify our own values and names to the primay and log files

example:
create database srinivas
   on
(
Name=srinivas,
filename='G:\srinivas.mdf',
size=5MB,
maxsize=15MB,
FileGrowth=1MB)
log on
(
Name=srinivas_log,
filename='G:\srinivas_log.ldf',
size=2MB,
maxsize=5MB,
FileGrowth=1MB
)

Note:

The above two examples will create a databse, whnever we create a database if we dont specify any options it will create two files named it as primary file and log file.

Primary  file will contain the objects that we create in our database,so this file contains all the tables,procedures,functions,views and all.

Log file contains all the commands that we executed over that database.

Size by using this attribute we will set the initial size of primary and log files.

MaxSize by using this attribute we will set the maximum size of primary and log files that they can store.

FileGrowth by using this attribute we will set the auto growth  size of primary and log files,once the primary and log files reaches to filled with data and unable to store next,the then it will update the size with this size automatically.

2.Syntax to Create a Table:

CREATE TABLE <TABLE_NAME>
(
COLUMN_NAME1 DATATYPE[SIZE],
COLUMN_NAME2 DATATYPE[SIZE],
COLUMN_NAME3 DATATYPE[SIZE],
.
.
)

Example

CREATE TABLE EMPLOYEE
(
EID INT,
ENAME VARCHAR(15),
SAL INT
)

NOTE:

Rules to be followed while we are giving names to columns and tables:

1.Table name and Column name should be one word,i.e the column name or table name con't contain any embedded space.

create table employee details
(
eid int,
ename varchar(15),
sal int
)

above one is invalid

create table employeedetails
(
eid int,
e name varchar(15),
sal int
)

above one is invalid
2.Names of columns or table can't start with a number

create table 2employeedetails
(
eid int,
ename varchar(15),
sal int
)

create table employeedetails
(
eid int,
2ename varchar(15),
sal int
)

Both of the above examples are invalid
3.The names of tables and columns should not start with special character

create table &employeedetails
(
eid int,
ename varchar(15),
sal int
)

create table _employeedetails
(
eid int,
ename varchar(15),
sal int
)

create table employeedetails
(
&eid int,
ename varchar(15),
sal int
)

All the above examples are invalid.

** underscore can be use in front of column name

we will see more examples of how to create procedures,views,indexes,functions in near future.

Thanks
GSV

Relation ships in SQl Server 2012

By default SQL server contains a relation ship between the two tables as "PARENT" and "CHILD",here the

PARENT table is called as independent table/dimension table which contains dimensions i.e the values in parent table will not change (mostly 99%)

CHILD table is called as dependent table/fact table which contains facts/measures i.e the values in child table contains facts/measures i.e it contains mostly (numeric values only in all the columns 95%) by using these we will perform the operations on these data.

parent and child relationship is with respect to type of data(based on dependable/not).

with respect to number of records present in two tables the relation ship is organized as below

one to one (1:1)
one parent record in parent table is related with one child record in child table.

One to Many(1:M)

one parent record in parent table is related with many child records in child table.

Many to One(M:1)

many parent records in parent table is related with one child record in child table.

Many to Many(m:m)

 it is a combination of (1:m and m:1) i.e if a two tables contains one to many and many to one relation ships the we can confirm that it is having many to many relation ship.

-->practically we can implement m:m relation ship with the help of "Bridge Table".

the following diagram explains all the relation ships

This diagram contains all the relation ships between project and emplist.

Thanks
GSV

Data Models

After inventing of DBMS, several models are proposed stating various ways of representing data within the database and their advantages, called as data models. These data models are classified into three categories based on their purpose as follows.

1. Physical Data Models
2. Conceptual Data Models
3. Logical Data Models

Physical Data Models : The data models that concentrate on how the data is physically stored within the database are called as physical data models.

Conceptual Data Models : The data models that concentrate on how the data and relationship between data can be represented diagrammatically are called as conceptual data models. One of the most popular conceptual model is Entity-Relationship Model(E-R Model).

E-R model uses the terminology Entity, Attribute and Relationship.  An entity is a real world object stored within the database. If you store student information in the database, then student is called an entity, if you store employee information within the database, then employee is called an entity and so on. An attribute is a characteristic feature of the entity. For student entity sid, sname, course, address all these are called as attributes. A relationship is an association between entities. Relationship between entities are classified into one to one(1:1), one to many(1:M) and many to many(M:N).

ER Diagrams:

Within E-R diagrams an entity is represented with a rectangle, an attribute with oval shape and relationship with diamond shape etc. 

The E-R diagram for the entities Student and Course is as follows. The relationship type between course and student is one to many. This is because one student can join only one course and a course can be chosen by any number of students.

                     

Logical Data Models : The data models that concentrate on what data is stored in the database and what type of relationship exist between data are called as logical data models. The following lists of logical data models are available.

1.    Hierarchical Data Model

2.    Network Data Model

3.    Relational Data Model

4.    Object Data Model

5.    Object Relational Data Model

Hierarchical Data Model : in this data model data is organized hierarchically like in tree data structure. Within hierarchical database model it is not possible to represent many to many relationships. This drawback leads to the development of network data model. Student information can be represented in hierarchical data model as follows.

Network Data Model : in this data model also data is represented same as in case of hierarchical data model except that it can represent many to many relationship. Student information is represented in network data model as follows.

     

  In both hierarchical and network data models, organization of data is very difficult as it is organized like a tree data structure. Especially deleting a record will be very complex process as all records that are based on deleted record must be rearranged. These drawbacks lead to the development of relational data model.

Relational Data Model : Relational data model was proposed by E.F.Codd in 1970. He proposed the model theoretically and first practical implementation of relational model was System-R and is developed by IBM Corporation. In relational data model data is organized in the form of attributes, tuples and relations. Attribute, tuple and relation can be compared to a field, record and file in file management system. These are technical terms given by E.F. Codd and now a days these terms are replaced with column, row and table respectively.

As organization of data in relational data model is similar to file management system, it is very easy to maintain when compared to hierarchical and network data models. Now a days most of the DBMS are RDBMS. Examples are SQL Server, Oracle,DB2, MS Access etc.,

Object Data Model : This data model is based on object oriented concepts of programming. This model provides OOP features within the database. This model also becomes popular as it has advantages of OOP. Examples are Object Store, Cactus etc.,

Object Relational Data Model : this model combines the features of object data model with the features of relational data model. Hence this model has both the advantages of relational data model as well as object data model. Example is Oracle 8.0 onwards.