zaneizane

 Profile Answers by zaneizane Questions by zaneizane

• Jul 22nd, 2008

This may be considered as the mapping of the data and data relations into an indefinitely large linear address space. This specifies some or all of the data structures necessary to support the data and data relations declared in the conceptual schema.

ALOK BATHAM VAISH

• Dec 24th, 2006

THhe overall design of the database is called Scheema.

Answer Question  Select Best Answer

indr

• Apr 6th, 2007

No up to 3nf it is not sufficient to normilize...coz 3nf contains redundancy problem....that can be removed by BCNF...so up to BCNF it is sufficient.....

Kalpesh Patel

• Jan 23rd, 2007

Third Normal Form is sufficient for most situations. But if that isn't normal enough for you.

Answer Question  Select Best Answer

Sheraz Baig

• Nov 22nd, 2013

GUI based

manishayadav_1

 Profile Answers by manishayadav_1 Questions by manishayadav_1

• Apr 9th, 2008

menu-driven

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Post block trigger belongs to Navigational triggers.

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Oct 24th, 2007

Navigation Trigger

Answer Question  Select Best Answer

Types of users with their duties using suitable examples

johnjustin

 Profile Answers by johnjustin Questions by johnjustin

• Apr 8th, 2008

There is no much difference between user and enduser. A person who uses a system or application is a user. If a software engineer uses Sql server for application development then the person is also ca...

abhay.parashar

 Profile Answers by abhay.parashar Questions by abhay.parashar

• Nov 19th, 2007

 The final or ultimate user of a computer system. The end user is the individual who uses the product after it has been fully developed and marketed. The term is useful because it distinguishes t...

Answer Question  Select Best Answer

Discuss the difference between unique and non-unique keys

mudkhedkar

 Profile Answers by mudkhedkar Questions by mudkhedkar

• Nov 7th, 2008

Unique - Take for example employee table, it has column empno which is called as unique key where as non-unique key is column workdept, i.e when we do relationship between two tables as employee & department tables, dept. table also contains deptno as column so it is called as non-unique key.

KamalChauhan

 Profile Answers by KamalChauhan Questions by KamalChauhan

• Jul 11th, 2008

Unique keys can have only one null value or rather i should say that every value in the column(which is marked as unique key) must be unique.

Answer Question  Select Best Answer

Why is the choice of primary key important and are three characteristics of an ideal primary key?

sanit kale

• Apr 24th, 2014

The PRIMARY KEY constraint uniquely identifies each record in a database table.

Primary keys must contain unique values.

A primary key column cannot contain NULL values.

Each table should have a primary key, and each table can have only ONE primary key.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 16th, 2009

Primary key will let the retrieval operation to be fast.It will not allow you to insert duplicate and null values.It is used to uniquely identify a row in a table.

Answer Question  Select Best Answer

What is an intersection table and why is it important?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

An intersection table implements a many-to-many relationship between two business components.

scud021

 Profile Answers by scud021 Questions by scud021

• Jul 20th, 2008

A table added to the database to break down a many-to-many relationship to form two one-to-many relationships

Answer Question  Select Best Answer

Differentiate between Controlled and Uncontrolled Redundancy

Azad

• Feb 13th, 2015

Drawback of traditional file system

supriya_pict

 Profile Answers by supriya_pict Questions by supriya_pict

• Sep 11th, 2009

Redundancy is Direct if a value is a copy of another Indirect if the value can be derived from other values: Simplifies retrieval but complicates update Conversely integration makes...

Answer Question  Select Best Answer

What is the relationship between a company's databases and its data warehouse?

Hirru

• Feb 10th, 2012

Database is a structured collection of relational data. Database is used to store the relational, network or hierarchical data. It contains some sort of data and it is being used by the organization...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important...

Answer Question  Select Best Answer

Explain a one-to-many strong vs. one-to-many weak entity relationship.

raman sharma

• Mar 2nd, 2012

Entity relationship when attribute are connected to entity there are different different type attribute are available weak entity and strong entity when we are using key that called strong entity and when key are not connected that called weak entity

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

Weak Entity generally don't possess key attributes of their own whereas a Strong Entity possess its own key attributes that are independent of other entities. Weak entity is usually existence-dependent on another entity type and does not have enough attributes to form its own primary key.

Answer Question  Select Best Answer

Been given this question from my son and he has told me that he googled the question but got no satisfactory answer. Would much appreciate an answer.

raman sharma

• Mar 2nd, 2012

DBMS is a when data are not stored in table and RDBMS is used to all data are stored in table and distributed database when more than one table are connected with each other so its is called a distributed database

suji

 Profile Answers by suji Questions by suji

• Dec 21st, 2011

DBMS - Its a software package combination of various computer programs which can be used to control, administer, maintain and use of the database. RDBMS - Its a database management system (DBMS) b...

Answer Question  Select Best Answer

Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help.

select ename,(select dname from dept where deptno=e.deptno) from emp e;

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Apr 11th, 2012

Youre using a Sub-query -- [(select dname from dept where deptno = e.deptno)] -- to get around using a join clause like -- [FROM EMP E INNER JOIN DEPT D ON (D.DEPTNO = E.DEPTNO)] -- however, you are n...

Blaster_Ayub_Khan

• Apr 10th, 2012

SQL coins the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database. All SQL queries perform some type of da...

Answer Question  Select Best Answer

I have a database with 5 millions records, i have Person table having 5 million records and its have 13 columns. Forename and surname column is heavily populated as compared to other columns. My question is it appropriate to separate forename and surname column and make separate tables for it and reference it with id in person_detail table. What are the advantages and disadvantages in separating these...

prakash

• Mar 9th, 2019

Advantage: Size of the table will decrease and so the query performance will be improved.
Disadvantage: Join query will be required to get surname and full name of person.

Asiimwe

• Jan 2nd, 2016

Its not good to separate them.

Answer Question  Select Best Answer

What is the difference between MS SQL Server and SQL Server? Are both same are not?

Mayank Sanghvi

• Mar 21st, 2018

Both are same. MS SQL Server means Microsoft SQL Server. SQL Server is the database developed by Microsoft. Because of this it is also known as MS SQL Server.

justin

• Dec 26th, 2017

Both are same

Answer Question  Select Best Answer

At what trigger timing does mutating trigger error occur?
Is it before/after or both? And is it for row level/statement level OR both?

Achyuth

• Oct 30th, 2017

When trying update a record by using a trigger which is already in use

anjali

• Mar 8th, 2017

The mutating error comes when we use a column in our trigger and we want to update it at the same time. It occurs in row level triggers irrespective of the fact whether it is before or after trigger.

Answer Question  Select Best Answer

Tejas Makwana

• Feb 12th, 2007

DBMS includes the theoretical part that how datas are stored in a table. It does not relate tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with a...

M.Mahesh Kumar

• Nov 24th, 2005

RDBMS is enabled nu static 2-dimensional tables. ADBMS is enabled by vector field and is n- dimensional.

Answer Question  Select Best Answer

ankit

• Mar 16th, 2007

jdbc.odbc

pranali patil

• Oct 19th, 2005

Its a jdbcodbc bridge

Answer Question  Select Best Answer

Sheraz Baig

• Nov 22nd, 2013

Subquery is basically Query Withing Query.. and the Result of Subquery is used by Outer query and Subquery could be at any level its not level restricted...

DIPTENDU HUI

• Jan 28th, 2006

1.Subquery is nothing but a query inside a query which appears only after the WHERE clause of a select statement.2.Two types of subquery is there:a) Co-Related subqueryb) Non-Co-related subquery.3. Us...

Answer Question  Select Best Answer

sri

• Oct 11th, 2006

We can normalize the many to many realationship, by creating a third table contaaining the primary keys of both the tables

sv_shali

 Profile Answers by sv_shali Questions by sv_shali

• Feb 18th, 2006

By creating a third relation table containing only the primary keys of both master tables.

Answer Question  Select Best Answer