1) Databases are used to store different kinds of data such as names, currency, text, graphics, etc

Subject:Computer SciencePrice:3.86 Bought6

Share With

1) Databases are used to store different kinds of data such as names, currency, text, graphics, etc. Determining the appropriate data type for each attribute is important for database performance, storage size, and conducting accurate analysis on databases. As with other programming languages, SQL supports many data types. However, you will mostly use two categories while writing SQL queries: Characters, and numbers.

Consider the following standard SQL data types:

• Characters
• char
• varchar
•  
• Numbers
• integer
• decimal
• float

Different data types could be used for the same attribute. For example, both char and varchar could be used to store "names" in a database. Examine the attributes for the Characters and Numbers data types.

Using specific examples, compare data types for each category. For example, why you should choose char rather than varchar or opposite

 

2.What are the implementation problems of Dates and Times data types in database? Discuss solutions for these problems.