Answer to Question #178746 in Databases | SQL | Oracle | MS Access for Karthickraja Dhakshinamoorthy

Question

Comment on her diagram, explaining which 10 changes you would recommend to improve the diagram to be more in line with the business rules. Also include improvements that would make it possible to implement the design in a relational database. Explain why you would make each change too, so she can learn from her mistakes.

Answer 1

The suggestion to improve the performance, are listed below-

1. We need to choose the appropriate data types.
2. We need to avoid nchar and nvarchar
3. We need to select null in the fixed-length field.
4. Avoid select * in the select statement.
5. We need to create clustered and non clustered indexes.
6. We need to keep clustered index small.
7. We always choose the normalized view of the data.
8. We need to use scripts to update the schema.
9. We need use view.
10. We need to use effective naming structure.