Answer: The DATE datatype give us the particular date whereas TIMESTAMP gives us the date as well as the time as the particular moment.
Explanation:
DATE datatype gives us the date in the format yyyy-mm-dd. The timestamp format is yyyy-mm-dd hh:mm:ss. time stamp are of two types :
timestamp with time zone and timestamp without time zone.
Date is the date on that particular day whereas the timestamp is the date along with the specific time when the query is executed.
A functional dependency describes a relationship between the attributes of an entity such that the value of one attribute is dependent on the value of some other attribute and is very well affected by it.
There can be various sources of information that define functional dependency. For instance, an attribute age can define the functional dependency with the attribute ID. One cannot include the voter ID if they are not above 18 years of age.
Similarly, the attribute date of joining can define the functional dependency with the attribute experience, as the experience in a particular organization can be calculated by subtracting the joining date fro the current date.
Answer:
See explaination
Explanation:
E-R diagram:
Entity Relationship Diagram, also known as ERD, ER Diagram or ER model, is a type of structural diagram for use in database design. An ERD contains different symbols and connectors that visualize two important information: The major entities within the system scope, and the inter-relationships among these entities.
Please kindly check attachment for for the ERD of the question asked.
Answer:
Option E Components that interact to produce information
Explanation:
Information system is a system to collect, analyze and disseminate information. An information system consists of five components that work with each other to produce information:
- Computer hardware - physical machine that works with information
- Computer software - a set of computer instructions that tell computer hardware how to perform a task
- Telecommunications - components that connect a group of hardware as to establish a network. This usually includes WiFI technology.
- Databases and data warehouses - the place where the digital data are kept and retrieved.
- Human resources and procedures - human expertise that run the system by following some standard procedures.
Answer: A. Using different cell styles can help you differentiate different types of data.
B. Fonts should be easily readable and of appropriate size.
D. Be consistent with themes across worksheets and workbooks.
Explanation:
A theme refers to the preset package that contains functionality details and graphical appearance.
The guidelines for using themes include:
• Using different cell styles can help you differentiate different types of data.
• Fonts should be easily readable and of appropriate size.
• Be consistent with themes across worksheets and workbooks.
Therefore, the correct options are A, B and D.
