Describe two disadvantages of surrogate keys. Explain why they are disadvantages. Surrogate keys has many advantages and disadvantages. Advantages: Surrogate keys are fixed and are unique within the table they are located. When the row that the key is associated …
Describe two disadvantages of surrogate keys. Explain why they are disadvantages. Read more »
Describe the two phases in designing databases that arise from the development of new information systems. The two phases of development of databases for a new information system are: Create a data model: point out the complexities that are might …
What is the purpose of read-only databases? The main purpose of making a database a read-only is to restrict the users from modifying certain aspects of the database. For example when a database is in read-only mode, an auto-shrink, auto …
Discuss and compare the advantages and disadvantages of three databases. SQL: Advantages: It is considered to be a high speed solution. It has established standards that are followed by all SQL database developers. It also does not require a huge …
Discuss and compare the advantages and disadvantages of three databases. Read more »
Why is SQL described as a data sublanguage? SQL is not a full functioning computer programming language like C++, Java or Visual C. Instead it is described as a “data sublanguage” because it provides a facility to process and create …
Describe why database redesign is necessary. Database redesign involves the redesign of an existing database to make room for required changes or to make other improvements to the database performance. There is no guarantee that a database will be 100% …
Review the three sources of database design and implementation. Following are the three sources of database design and implementation: Existing data: What type of data is presently stored in the database? How is it stored i.e. the structure of the …
Review the three sources of database design and implementation. Read more »
Summarize the key advantages of stored procedures. Stored procedures are assigned to databases. They are in the form of programming procedures which are used to perform some common actions on the data that is contained in the database. They can …
Summarize the key advantages of stored procedures. Read more »
What is the relationship between a trigger and a table or view? A trigger is a specific program that is kept inside a database management system. It waits for a specific event to take place and as it takes place, …
What is the relationship between a trigger and a table or view? Read more »
What is a user-defined function? User defined function is a small program that can perform some operations defined by the user. Database languages like SQL has many built in functions like he functions used for different arithmetic functions which can …