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
explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas

What is a view? How it is related to data independence? A view might be thought of as a virtual table, that is, a table that does not really exist in its own right but is inste

i want notes on this topic

construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

I want Database Of United Kingdom with Criteria of:\r\n\r\n1). Name, Number, City, State, Postal Code, Address, Email id, DOB.\r\n\r\n2). Unsecure Debts only adds Credit Card Payme

Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abs


Name the metrics for selecting top algorithm There are a number of metrics for selecting top algorithm: i) Computational complexity: Computational complexity refers to eff