Difference between data and information, and how are they related in a database?

966

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

1921

How index hunting contributes in improving the query performance?

952

What are the 4 types of database?

1023

What do you understand by ‘atomicity’ and ‘aggregation’?

898

why an information gap exists in most organizations.

1004

What is difference between database and spreadsheet?

1044

Define normalization.

954

What is pdo in database?

887

What is meant by database system?

903

What is database in simple language?

900

Compare non-clustered and clustered index

879

What are the importance of partitioning in dbms?

960

Explain the terms ‘attribute’ and ‘relations’

1142

what is normalization? types of normalization? example of each form? how do u implement normalization in ur project?

1858