Our tutors can help students from all over the world who might need help in any course from different study areas.
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 …
What does DDL stand for? List the SQL DDL statements. DDL stands for Data Definition Language which is used for creating tables relationships and other database structures (Kroenke & Auer). DDL is a set of commands that can manupulate tables, …
What does DDL stand for? List the SQL DDL statements. Read more »
List four common design problems when creating databases from existing data. Following are the four common design problems when databases are created from existing data: The multivalue, multicolumn problem Inconsistent Values: There are values that are inconsistent with regards to …
List four common design problems when creating databases from existing data. Read more »
Summarize how database design principles differ with regards to the design of updateable databases and the design of read-only databases. Database design principles have different implications when it comes to designing updateable databases vs read-only databases due to their unique …
Under what conditions will a determinant be unique in a relation? In a table or a relation, for a determinant to be unique, it must determine all other columns in that specific table or relation. As we know that two …
Under what conditions will a determinant be unique in a relation? Read more »