Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2002
    Location
    Pakistan
    Posts
    1

    Lightbulb Unanswered: SQL Plus "Normalization"

    NORMALIZATION
    Normalization aims to improve the Logical Design by making it free of redundant data and flexible enough to permit the future addition of entities, attributes and relationships.

    There are diffrent levels of Normalization.

    First Normal Form (1NF)
    Second Normal Form (2NF)
    Thrid Normal Form (3NF)

    Q: Any body kindly explain how we can make some data to Normalization in SQL Plus. ?
    Thanks.
    My e-mail : mcsit2002@yahoo.com

  2. #2
    Join Date
    Apr 2002
    Location
    Calgary, Canada
    Posts
    30
    you would normalize the entities of a database. This has nothing to do with SQL plus. This would be in the design stage of database modeling.

    If you mean you want to get the column names etc from the db to normalize then that can be done is sql plus

    desc your_table_name

  3. #3
    Join Date
    May 2002
    Location
    delhi (india)
    Posts
    4

    Thumbs up

    hello,

    Normalization is always done at design level.
    once the relationships are defined nothing can be done using sql - plus.
    it is just the means to ask/give data from/to database.

    if ur trying for query tunning, then there r possibilities.

  4. #4
    Join Date
    May 2002
    Location
    London
    Posts
    4
    Originally posted by c.ravi
    hello,

    Normalization is always done at design level.
    once the relationships are defined nothing can be done using sql - plus.
    it is just the means to ask/give data from/to database.

    if ur trying for query tunning, then there r possibilities.
    Normalizaton "should" always be done at design level but modifications can be caried out on the database using SQL. Dropping table columns etc all have an effect on the data although I would not suggest it unless you know what you are doing. You can continue to redefine your database after the initial design and SQL is the tool used to make these changes.

  5. #5
    Join Date
    May 2002
    Location
    delhi (india)
    Posts
    4

    Exclamation

    hello hjackson,

    true, i agree with u .

    but thats not good practise changing the table structure after the initial design is done. what i wrote was in this context.

    And as u said Sql IS used for doing modifications.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •