What is database normalization?

Some years ago, when I was start working as junior database administrator, one of seniors given me a conceptual data model sheet and asked me to read the model and prepare a logical model from the sheet. I studied ER diagram (Entity-Relationship diagram) during my engineering course, so I must have some basic knowledge, but the given conceptual model is little different from what I studied (only the symbols are different). So I was searching in internet with queries, "what is logical data model?" and "how to convert a conceptual data model to a logical data model?". I found some pages related to what I was searching and I understood the concept, after a week somehow I submitted my newly created incorrect logical data model to my senior (it is a simple user management application).


During that process I came across a term "Normalization" (I did incorrect Normalization without knowing the actual term for that process in my first task given by my senior) in some web pages with examples. At that time I could not understand the Normalization with the mentioned example. So I thought to write a post on normalization, intent of this post is to share the concepts of database normalization for beginners with a simple example. After reading this post you will be able to answer the following question.  

What is logical data model?
What is normalization?
What are the levels of normalization?
What is first normal form (1NF)?
What is second normal form (2NF)?
What is third normal form (3NF)?

Logical Data Model:


We have seen about the conceptual data model in the previous post, in which we used the school management application as our example. In CDM we capture the basic and critical concepts of a school, so the next step will be capturing the business requirements. The logical data model is a business solution. This model is independent of implementation concerns such as software or hardware. Logical data model uses business names for entities and data fields such as Customer, Order Number.

The logical model includes all of the data fields and business rules. For example, in our conceptual data model example, A Teacher may teach many Subjects. The logical data model will capture all of the details behind the Teacher and Subject entities, such as teacher's name, identity, address, subject name, code, level, etc. Logical data model is based on the conceptual data model and it provides a base for physical data model (database). 


Normalization:


When I was working in our carrot field with my Mom, she asked me to pack the carrot basket for selling in the market to our customer. So I categorized each basket according to size, color and variety. Organizing the carrot baskets in this way helped me to understand the carrot size and their variety. This helped us to sell our products in better price in the market. 

We apply set of rules to achieve the goal of organizing something. In our carrot field, I applied the rules, such as size, color and variety to organize the carrot baskets. Similarly, in simple words normalization, is the process of applying set of rules to organize entities and data fields within our database. These rules are based on the business process in our organisation.  

Normalization process involves the spliting of a entity into less redundant and smaller entities without losing data instances, in our example (below) we will see why we are splitting. Series of rules are applied at different levels, each level includes the rules of the lower level. Let us see those normalization levels in detail.


Levels of normalization:


Levels of normalization is given below,

First normal form (1NF)
Second normal form (2NF)
Third normal form (3NF)
Boyce/Codd normal form (BCNF)
Fourth normal form (4NF)
Fifth normal form (5NF)

Each level includes the rules of the lower levels. For example, if a model is 4NF, it is also in BCNF, 3NF, and so on. Usually we call a model is normalized if it is in 3NF. This is because the higher levels normalization (BCNF, 4NF and 5NF) used for specific situations that occurs very rarely. So in this post we are going to see about only first, second and third normal forms.

In normalization process we need to make sure that, every data field is atomic and uniquely provides a fact and only about its primary key.

For example, lets consider a website company, a subset of conceptual data model for this website is given below.

User Conceptual Model
USER CONCEPTUAL MODEL







Initially all the data fields can be assigned to one entity, the User itself. The following diagram shows the User entity with data fields:

USER ENTITY AT BEGINNING
USER ENTITY

When we assigning all the data fields to User, we need to have a clear definition for User. Since different people or organisations may have different interpretation for the term User. 

A person, a company or a person from a company who access our website.

We know the definition for the User, now we have to answer the question, how can a website owner or admin identify a specific User?, What is uniquely identify a User?, or What data field used to uniquely identify a User?

In order to answer to above questions, we can assume that, user id with user email address uniquely identify a User. So the new User entity model with the primary key will be as look like follows:

USER ENTITY WITH CANDIDATE KEY

Note that, while choosing primary key, we need to consider many rules, most important of them are, we cannot use sensitive information as primary key also, we need to choose the data field which is short in length. In our model, the selected primary keys are just for illustration purpose.

In the above entity model, the User Id is just a number and therefore the values do not have to be a sequential number. So it may contain duplicate values,    we are going to remove redundancies by applying the series of rules mentioned in the normalization process.


First normal form (1NF)


First normal form ensures that, domain of every data field must contain only atomic (single) values and the value of each data field contains only single value.

In simple words, when a business person asks for name of the user id 1, the system must return only one value Steve. It should not return John and Steve. Also, it should return single value from that domain. For example, Person Name may contain multi values such as "Steve Jobs", first normal form split this multi value into a single value by spliting the data field as Person First Name and Person Last Name.
  
First normal form will eliminate the repeating data fields and multi valued data fields. Let us discuss about this rules here.

Now come to our website company model, what if someone has two or three Phone Numbers? For example, consider a User Raj having two phone numbers, in order to accommodate this requirement, our User model will be altered as showing below:

REPEATING DATA FIELDS

In this model, the data field Phone Number repeated twice, so this violates the first normal form. Also there is a chance in future, a User may use more than two phone numbers like three or five and so on. In general a User can have more than one Phone Number. So we need to resolve this repeating data fields issue.

In order to resolve this repeating data fileds, we are creating a separate entity called User Phone Numbers. By creating one-to-many relationship with this User Phone Number, we can satisfy the business rule "Each User can have one or many User Phone Number", so the new User model may look like this:







REPEATING DATA FIELDS RESOLVED
REPEATING DATA FIELDS RESOLVED

Now, lets say, a Phone Number is used by more than one User. For example, a Phone Number 97872 11111 used by both Raj and Kumar. A model must resolve this need, we are creating a many to many relationship with the User. So the User model will be altered as follows,

USER AND PHONE NUMBER MANY TO MANY
USER AND PHONE NUMBER MANY TO MANY

We have solved the repeating data fields in the User model, yet the model is not in the first order. What if the business people asks for only Persons first name? what if the business asks for persons last name? and what if the business people asks for phone number of a particular country or particular area? As a data modeler you need to ask such questions with business people as well as to yourself. 

Most of the time, we are dealing with present business requirements, but as a data modeler you have to think in terms of future business needs, in future we have additional set of requirements, so we need to model our system in such a way that accommodate  future requirements as well.

Now lets come to our User model, in our model, what if the website owner asks for only person first name or last name? In our model, we have only Person Name which contains name values. For example, Person Name contains the value Bill Gates. When we need only first name we need to split the data field into separate data fields, such as Person First Name and Person Last Name, so that we can solve this multi-valued data fields issues. 

Every data field must contain only single atomic value, so the new model may looks like as follows:

USER MODEL IN 1NF
USER MODEL IN 1NF

Lets say you are modeling an application which is used only within your particular geographical area. For example, I was working with one of my clients, and my assignment was model for a billing application, which is used only by their employees who are all from within our country. Out of my interest, I referred some modeling books, I developed a model, which include the separate data field for Area Code, Country Code and Phone Number.

When I submitted my model, the requirement of the client was completely different, They don't need the separate fields for area and country code. Since there are no outside employees and they don't hire the outside employees for their field work. So they just needs the Phone number with area code in the same field. My effort for modeling those entities was not required. In our model just for illustration purpose we added a new data field Area Code in Phone Number entity.

Some times we may face such kind of situation where even the data field contains more than one value we need to consider them as atomic values. Make sure to ask questions to business people and make the requirements clear so that you can save the extra modeling efforts and time.










Second normal form (2NF):


We have already know that, each level of normalization includes the rules of the lower level of normalization, so a model in second normal form includes the rules of first normal form.

A model is in second normal form (2NF), if it is in first normal form (1NF) and every data field in the entity is dependent on any proper subset of candidate key of the entity. This means that, each entity must have minimal set of candidate keys that uniquely identifies each entity instance. 

In our User model example, the minimal set of candidate key instances are User Id and Email Address. Do we need both the User Id and Email Address to retrieve a single instances of each data field? No, we do not need both the User Id and and Email Address as primary keys in User entity. Either one of these is enough to uniquely identify a user and return a single instance of any of the data fields in the User. So we just need one of these as primary key.

We have already seen about the keys in data modeling and choosing a primary key from the set of candidate keys in previous post. By applying those criteria we chose User Id as the primary key and Email address as an alternate key. So the new updated model will be shown below:


USER MODEL WITH MINIMAL SET OF CANDIDATE KEY
USER MODEL - MINIMAL SET OF CANDIDATE KEY

Also analyzing the User model with the same view, we are getting the following questions, Is data field Gender applies to Company? Is data field Logo Image applies to Person? The answer is no as per our website company requirement, so we are introduce sub-typing into our model.  The updated model will be shown below:

USER MODEL WITH SUBTYPING
USER MODEL WITH SUB-TYPING

In the above diagram, you can see that, the data fields Person First Name, Last Name Title, Gender, Birth Date belongs to entity Person and Company Name and Logo Image data fields belongs to Company and data fields Email Address, Web Address, Address Line , City, State and Country shared by both Persona and Company. Also you can see that, both the Person and Company share same primary key User Id, that is primary key of the super-type user, since super-type and subtype share one-to-one relationship.

Lets recall the definition of the entity User, "a person, a company or a person from a company who access our website". As per the definition, we have to assign the relationship between the Person and Company. The following questions reveal the relationship between the Persona and Company.

Can a Person work for more than one Company? 
Can a Person exist without a Company?
Can a Company employ more than one Person?
Can a Company exist without a Person?

The answer for these questions are, a Person can work for one Company or no company at all and a Company can employ one or many Persons or no Person at all. The following diagram shows this model:

USER MODEL IN 2NF


Third normal form (3NF):


In simple words, third normal form deals with "nothing but the key". A model is in third normal form, if and only if the model is in second normal form (2NF) and every non-candidate key in the entity determined only by the candidate keys of that entity and not by any non-candidate key.

In third normal form we are going to remove hidden dependencies. Except alternate key and foreign keys all other data fields in the entity must directly dependent on the primary key of the same entity. When analyzing our User model, we see that there are some hidden dependencies within the address data fields. If we know the PIN code we can determine the city, state and country. Therefore, we move postal code, city, state and country to a different entity. 

The relationship between the User and new entity Address can be identified by asking the following questions, 

Can a User belongs to more than one City? 
Can a User exists without a City? 
Can a City contains more than one User? 
Can a City exists without a User?

A user belongs only one city and a user cannot exists without a city, also a city can contain more than one user also there are cities without a user. Therefore, the redefined model will like as follows:

USER MODEL IN 3NF
USER MODEL IN 3NF

The above diagram explains the model which is third normal form (3NF), once you learn the concept of normalization, it is not necessary to start the normalization from step by step. You can apply all levels at once. Also you can further normalize this model depends upon the requirements, but keep in mind this extra modeling efforts must be used only when it is necessary, since it may further delay the project allotted time and resources.

USER MODEL IN NORMALIZED FORM
USER MODEL IN NORMALIZED FORM

Note that in the above mentioned model, primary key names of the sub-types are changed for our convenience and it still reference the super-type primary key. I hope this post will help you to understand the normalization in logical data modeling. In next post let us discuss about the abstraction in logical data modeling. I expect your valuable feedback, kindly share your thoughts on comments section.

97 comments:

  1. SQLite is broadly upheld by different programs,click here working frameworks, implanted frameworks and numerous different applications. I

    ReplyDelete
  2. When we talk about data recovery in this report, we will fundamentally concentrate on issues encompassing hard drive disappointments; since these kinds of disappointments are generally normal. restore deleted data

    ReplyDelete
  3. The video poker machine will show its payout table and the base hand equipped for a payout relies upon the individual betting machine. machine learning course in pune

    ReplyDelete
  4. Very nice info. Thanks for letting it know https://electroalert.blogspot.com/2019/10/television-in-republic-of-india-is.html

    ReplyDelete
  5. This is actually very informative Elctroalert
    electroalert

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Good day! I just want to give you a huge thumbs up for your excellent info you have right here on this post. I will be coming back to your site for more soon. onsite mobile repair bangalore When I originally commented I appear to have clicked the -Notify me when new comments are added- checkbox and from now on whenever a comment is added I get 4 emails with the exact same comment. Is there a way you are able to remove me from that service? Cheers! asus display repair bangalore The very next time I read a blog, I hope that it does not disappoint me just as much as this particular one. I mean, Yes, it was my choice to read, but I really believed you would have something helpful to talk about. All I hear is a bunch of complaining about something that you can fix if you were not too busy searching for attention. huawei display repair bangalore

    ReplyDelete
  8. Spot on with this write-up, I honestly believe this website needs much more attention. I’ll probably be returning to read more, thanks for the info! online laptop repair center bangalore You are so cool! I do not think I've read through anything like that before. So good to discover somebody with a few genuine thoughts on this subject. Seriously.. many thanks for starting this up. This web site is something that's needed on the internet, someone with a bit of originality! dell repair center bangalore

    ReplyDelete
  9. I like looking through a post that can make men and women think. Also, thanks for permitting me to comment! macbook repair center bangalore Right here is the perfect website for anybody who really wants to find out about this topic. You understand so much its almost tough to argue with you (not that I really would want to…HaHa). You definitely put a new spin on a topic that's been written about for years. Wonderful stuff, just wonderful! acer repair center bangalore

    ReplyDelete

  10. Really useful information.

    Data science Course in Mumbai

    Thank You Very Much For Sharing These Nice Tips..

    ReplyDelete
  11. I think that thanks for the valuabe information and insights you have so provided here. Interested in bootstrap crud? Learn about it at phpcrudgenerator.com

    ReplyDelete
  12. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    data analytics course mumbai

    data science interview questions

    business analytics courses

    data science course in mumbai

    ReplyDelete
  13. You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
    machine learning courses in mumbai

    ReplyDelete
  14. back to life and extending future in diseases like hyper pressure, heart issues and diabetes. They help to lighten the agony for individuals who have become casualties of mishaps, wounds, activities and degenerative sicknesses like joint inflammation.
    modvigil

    ReplyDelete
  15. It was a great blog with so much information of the beautiful places to visit...Sarkari Result has currently published jobs like India Post GDS Online Form, Bank of Maharashtra Recruitment,, AIIMS recruitment, MPPKVVCL Recruitment, Indian Navy Recruitment, Vizag Steel and many more. So, never miss a chance to check out Sarkari Result on daily basis for getting all the information about RRB Recruitment 2020 .

    ReplyDelete
  16. It’s interesting content and Great work....Most of the part want to analyze their individual scores in the exam. In this process of checking your Exam Latest Result, We support you by giving the Result links to get you All India Sarkari Result in an easy way.

    ReplyDelete
  17. Other content online cannot measure up to the work you have put out here. Your insight on this subject has convinced me of many of the points you have expressed. This is great unique writing.

    SEO services in kolkata
    Best SEO services in kolkata
    SEO company in kolkata
    Best SEO company in kolkata
    Top SEO company in kolkata
    Top SEO services in kolkata
    SEO services in India
    SEO copmany in India

    ReplyDelete
  18. This is a great information. Thanks for providing this info. bravesites

    ReplyDelete
  19. This is one of the best blog about Technology. Thanks - Virtual Assistant

    ReplyDelete
  20. I feel very thankful that I could read that awesome article. The way you provide values through your article is incredible. Thanks for sharing. Keep posting


    SEO services in kolkata
    Best SEO services in kolkata
    SEO company in kolkata

    ReplyDelete
  21. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
    machine learning courses in bangalore

    ReplyDelete
  22. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    Data Science Training Institute in Bangalore

    ReplyDelete
  23. I’m excited to uncover this page. I need to to thank you for ones time for this particularly fantastic read!! I definitely really liked every part of it and i also have you saved to fav to look at new information in your site.
    data science course hyderabad

    ReplyDelete
  24. I am really enjoyed a lot when reading your well-written posts. It shows like you spend more effort and time to write this blog. I have saved it for my future reference. Keep it up the good work.Java training in Chennai

    Java Online training in Chennai

    Java Course in Chennai

    Best JAVA Training Institutes in Chennai

    Java training in Bangalore

    Java training in Hyderabad

    Java Training in Coimbatore

    Java Training

    Java Online Training

    ReplyDelete
  25. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful.

    data science courses

    ReplyDelete
  26. I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!

    Azure Training in Chennai

    Azure Training in Bangalore

    Azure Training in Hyderabad

    Azure Training in Pune

    Azure Training | microsoft azure certification | Azure Online Training Course

    Azure Online Training

    ReplyDelete
  27. Really nice and interesting post. I was looking for this kind of information and enjoyed reading this one. Keep posting. Thanks for sharing.
    360DigiTMG

    ReplyDelete
  28. Nice blog, it’s so knowledgeable, informative, and good looking site about normalization in used for DBA handle the data. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.
    DevOps Training in Chennai

    DevOps Online Training in Chennai

    DevOps Training in Bangalore

    DevOps Training in Hyderabad

    DevOps Training in Coimbatore

    DevOps Training

    DevOps Online Training

    ReplyDelete
  29. It has fully emerged to crown Singapore's southern shores and undoubtedly placed her on the global map of residential landmarks. I still scored the more points than I ever have in a season for GS. I think you would be hard pressed to find somebody with the same consistency I have had over the years so I am happy with that.
    data analytics courses

    ReplyDelete
  30. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
    IELTS Coaching in chennai

    German Classes in Chennai

    GRE Coaching Classes in Chennai

    TOEFL Coaching in Chennai

    spoken english classes in chennai | Communication training


    ReplyDelete
  31. 360DigiTMG_vizag27 August 2020 at 08:26

    Nice and helpful article!! Thanks for sharing such an informative post.

    360DigiTMG

    ReplyDelete
  32. cool stuff you have and you keep overhaul every one of us
    Data Analyst Course

    ReplyDelete
  33. I wanted to thank you for this great post!! I definitely enjoying every little bit.
    360DigiTMG Data Science Training in Hyderabad

    ReplyDelete
  34. I can configure my new idea from this post. Detailed information is given. Thank you all for this valuable information...

    360DigiTMG Data Analytics Course in Bangalore

    ReplyDelete
  35. This post is very simple to read and appreciate the information shared on the blog was useful.
    Data Analytics Certification Training 360DigiTMG

    ReplyDelete
  36. It is a great pleasure to read your message. It's full of information I'm looking for and love to post a comment that says "The content of your post is amazing". Excellent work.

    Artificial Intelligence Course in Bangalore

    ReplyDelete
  37. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it. 360DigiTMG

    ReplyDelete
  38. Attend The data science course in Hyderabad From ExcelR. Practical data science course in Hyderabad Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The data science course in Hyderabad. data science course in Hyderabad

    ReplyDelete
  39. Randomly found your blog. You have share informative information. Thank You.

    Data science course in Mumbai
    Data science course in Pune
    RPA training in Mumbai

    ReplyDelete
  40. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.Data science certification!

    ReplyDelete
  41. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.data science courses

    ReplyDelete
  42. I truly like only reading every one your web logs. Simply desired to in form you which you simply have persons such as me that love your own work out. Absolutely an extraordinary informative article. Hats off to you! The details which you have furnished is quite valuable.

    ReplyDelete
  43. Not many writers can persuade me to their way of thinking. You've done a great job of doing that on many of your views here.


    IT managed services provider in London

    ReplyDelete
  44. Really i found this article more informative, thanks for sharing this article! Also Check here

    ReplyDelete
  45. Top quality article with very fantastic information and unique content found very useful thanks for sharing.
    Data Analytics Course Online

    ReplyDelete
  46. Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.

    Data Science certification in Bhilai

    ReplyDelete
  47. Join the Great Sacred Illuminati Cult to option wealth and protection. Are you a business individual, politician, musician,footballer e.t.c? Do you want to be a famous artist or an actor and be powerful in the world? Become a member and receive the sum of $700,000.00USD, A house to live and also receive $200,000.00 monthly as membership benefit, get funded with money to start up business. This is real and no human sacrifices/soul selling so inbox me if you're interested +1(364)202-5427

    ReplyDelete
  48. It's good to visit your blog again, it's been months for me. Well, this article that I have been waiting for so long. I will need this post to complete my college homework, and it has the exact same topic with your article. Thanks, have a good game.

    Artificial Intelligence Course in Bangalore

    ReplyDelete
  49. Absolutely an extraordinary informative article. Hats off to you! The details which you have furnished is quite valuable. Tableau Course in Bangalore

    ReplyDelete
  50. This is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the leisure here! Keep up the good work. I have been meaning to write something like this on my website and you have given me an idea.

    data science course in India

    ReplyDelete
  51. This is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the leisure here! Keep up the good work. I have been meaning to write something like this on my website and you have given me an idea.
    Data Analyst Course

    ReplyDelete
  52. This is my first time i visit here. I found so many entertaining stuff in your blog, especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the leisure here! Keep up the good work. I have been meaning to write something like this on my website and you have given me an idea.
    Data Analyst Course

    ReplyDelete
  53. I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
    data science training

    ReplyDelete
  54. I have bookmarked your site since this site contains significant data in it. You rock for keeping incredible stuff. I am a lot of appreciative of this site.
    data science courses in delhi

    ReplyDelete
  55. Admittedly this isn’t always easy, especially if there are several hundred of them. But you’ve given me my knowledge I am searching for.
    data analytics course

    ReplyDelete
  56. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me..
    data science course in aurangabad

    ReplyDelete
  57. Thank you, this article is very inspiring and increases knowledge

    I hope the writer and the team will be more successful
    Allow me to give also information about desain interior

    ReplyDelete
  58. Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!
    data science online course

    ReplyDelete
  59. Very good message. I stumbled across your blog and wanted to say that I really enjoyed reading your articles. Anyway, I will subscribe to your feed and hope you post again soon.

    ReplyDelete
  60. you blog is very useful SAP bods learners.very informative content and detailed topic explanation.one of the recommanded content.we are very glad to leave a comment here.thank you for sharing your knowledge.also visit our blogs
    Database Developer Training in Bangalore

    ReplyDelete
  61. I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place
    business analytics course in Guwahati

    ReplyDelete
  62. I'm glad I found this blog! Occasionally, students want to know the keys to writing productive literary essays. Your first-class knowledge of this great job can become a suitable foundation for these people. Good...

    Data Science Institutes in Bangalore

    ReplyDelete
  63. top five engineering colleges in hyderabad

    Based on the 2021 Recent survey, Engineering is also one of the top and leading courses in India. Telangana, India has many best and top engineering colleges to study and it stands in second place for ‘EASY OF DOING BUSINESS’ in India. Hyderabad is the “IT HUB” of Telangana, India and it has been the permanent capital of Telangana for a long time and has attracted major IT companies in the city. The Hi-tech city which has almost all the top silicon valley companies established its campuses in Hyderabad. There are nearly 300+ companies that have their institutions in Hyderabad.

    ReplyDelete
  64. top five engineering colleges in hyderabad

    Based on the 2021 Recent survey, Engineering is also one of the top and leading courses in India. Telangana, India has many best and top engineering colleges to study and it stands in second place for ‘EASY OF DOING BUSINESS’ in India. Hyderabad is the “IT HUB” of Telangana, India and it has been the permanent capital of Telangana for a long time and has attracted major IT companies in the city. The Hi-tech city which has almost all the top silicon valley companies established its campuses in Hyderabad. There are nearly 300+ companies that have their institutions in Hyderabad.

    ReplyDelete
  65. Really impressed! Everything is a very open and very clear clarification of the issues. It contains true facts. Your website is very valuable. Thanks for sharing.

    Data Science Training in Bangalore

    ReplyDelete
  66. Top five engineering colleges in Hyderabad 2021

    Hyderabad has also been the hub for best and top engineering colleges and has some national and prestigious institutions like IIT Hyderabad and an International institute like IIIT Hyderabad one of the best in Telangana India, In this article you will find some of top engineering colleges in Hyderabad.. Check it out.

    1.INDIAN INSTITUTE OF TECHNOLOGY – [IIT], HYDERABAD

    2.INTERNATIONAL INSTITUTE OF INFORMATION TECHNOLOGY – [IIIT], HYDERABAD

    3.JNTUH COLLEGE OF ENGINEERING HYDERABAD (AUTONOMOUS) HYDERABAD

    4.UNIVERSITY COLLEGE OF ENGINEERING, OSMANIA UNIVERSITY – [UCE], HYDERABAD

    5.CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY – [CBIT], HYDERABAD


    https://www.graduatesengine.com/top-five-engineering-colleges-in-hyderabad/


    ReplyDelete
  67. Top five engineering colleges in Hyderabad

    To get into these engineering colleges, students after intermediate have to qualify in State entrance exams like TS EAMCET and for some National institutions like JEE Advanced and JEE Main and obtain marks according to the college cut-off to get admission into the college.

    1.INDIAN INSTITUTE OF TECHNOLOGY – [IIT], HYDERABAD

    2.INTERNATIONAL INSTITUTE OF INFORMATION TECHNOLOGY – [IIIT], HYDERABAD

    3.JNTUH COLLEGE OF ENGINEERING HYDERABAD (AUTONOMOUS) HYDERABAD

    4.UNIVERSITY COLLEGE OF ENGINEERING, OSMANIA UNIVERSITY – [UCE], HYDERABAD

    5.CHAITANYA BHARATHI INSTITUTE OF TECHNOLOGY – [CBIT], HYDERABAD

    https://bit.ly/3sDw0M6


    ReplyDelete

  68. Top Five Engineering Colleges In Hyderabad

    Engineering is the best choice for people who are really into the subject, It enhances your skill to think technically and give you better job prospects in future. Now, only top colleges can give you such exposure and knowledge of the subject, here in this article you will find top five engineering colleges in Hyderabad to choose from so that you can have a bright future. Click on the link below for the article.

    ReplyDelete
  69. I am a new user of this site so here i saw multiple articles and posts posted by this site,I curious more interest in some of them hope you will give more information on this topics in your next articles.
    tableau training in guduvanchery

    ReplyDelete
  70. Fantastic blog with excellent information and valuable content just added your blog to my bookmarking sites thank for sharing.
    Data Science Course in Chennai

    ReplyDelete