Guidelines for creation of table, Database Management System

Guidelines for creation of table:

  • Table name should begin with an alphabet.
  • In table name, single quotes and blank spaces are not allowed.
  • Reserve words of that DBMS cannot be used as table name.
  • Size and Proper data types should be specified.
  • Unique column name should be specified.

 

Posted Date: 3/11/2013 12:54:52 AM | Location : United States







Related Discussions:- Guidelines for creation of table, Assignment Help, Ask Question on Guidelines for creation of table, Get Answer, Expert's Help, Guidelines for creation of table Discussions

Write discussion on Guidelines for creation of table
Your posts are moderated
Related Questions
Illustrate about the advanced object design Advanced object design is a complex task. The objects discovered through analysis serve as a skeleton of design. The operations reco

What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.

Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the

Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte

What is multiplicity in the associations? Give an example to explain multiplicity? Multiplicity in association indicate number of objects participate in any relationship. For

Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.

need a DBMS system on any data for assignment.

Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio

Explain the Difference between DROP and DELETE DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from th