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
State the meaning of Object Representation  The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

What does Aggregation mean?

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Indexed (Indexed Sequential) File Organisation It organises the file like a big dictionary, i.e., records are kept in order of the key but an index is stored which also allows

Create Student DB and execute Insert query? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course

Chapter 1 - Profile for the Organization You have to select an organization of your choice and assume that you work for that organization. Now you must prepare a brief profile of t

Question 1 Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? Question 2 With a necessary example explain (i)

What is DML (Data Manipulation Language)? This language that enable user to access or manipulate data as organised by appropriate data model. Procedural DML or Low level: DM

construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d

Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca