Summarize how database design principles differ with regards to the design of updateable databases and the design of read-only databases. The very nature of updatable and read-only database is different. Updatable databases are accessed by user and amended while read-only …
When you receive a set of tables, what steps should you take to assess their structure and content? In database management and development it is important to properly assess data in data tables in respect to their structure and content. …
Under what conditions will a determinant be unique in a relation? In a relation a determinant is unique when it determines the data that is consisted in all other columns. ID is an example of a unique determinant. For example …
Under what conditions will a determinant be unique in a relation? Read more »
Explain the difference between functional dependencies that arise from equations and those that do not. Functional dependencies are used to uniquely relate different attributes to other attributes. Their main use is in the case of arithmetic operations when they are …
Explain the three different sets of terms used to describe tables, columns, and rows. There are different terms used to signify tables, columns and rows. For example columns add up attributes to the data in the columns and therefore they …
Explain the three different sets of terms used to describe tables, columns, and rows. Read more »
Must all the values in the same column of a relation have the same length? No it is not necessary for a column in a table to have the same data when speaking of the length of the data. There …
Must all the values in the same column of a relation have the same length? Read more »
Suppose that two columns in two different tables have the same column name. What convention is used to give each a unique name? This happens often in database development when there are multiple tables with same column names. This could …
Design an updateable database to store data received from another source. It is possible that a databased developed may be based on some fixed data that is fed once from a single or multiple sources and the database is then …
Design an updateable database to store data received from another source. Read more »
Describe a basic SQL SELECT/FROM/WHERE framework as the basis for database queries. Structure Query Language (SQL) is a powerful database related computer language that is used to write new information to the database and retrieve or delete existing information in …
Describe a basic SQL SELECT/FROM/WHERE framework as the basis for database queries. Read more »
Describe and provide an example of an entity-relationship (E-R) diagram. In our day to day database use, we need to identify data in database tables with the help of identifiers that may be present in other tables. To make these …
Describe and provide an example of an entity-relationship (E-R) diagram. Read more »