Question Type: # Of Questions: # Correct:
Multiple
... [Show More] Choice 22 12
Essay
4 N/A
1. Question :
(TCO 5) To edit a form, use
Question 2
.
Question :
(TCO 5) Clicking on the form tool will open a(n)
Question 3
.
Question :
(TCO 6) Which of the following describes a poor design consideration for a form?
Student Answer:
Question 4
.
Question :
(TCO 6) After running a query, which view will be shown?
Question 5
.
Question :
(TCO 7) When making vertical data comparisons, you should use the following chart.
Question 6
.
Question :
(TCO 7) Which of the following statements best describes data mining?
Question 7
.
Question :
(TCO 8) A switchboard is a
Question 8
.
Question :
(TCO 9) Open Exclusive means that
Question 9
.
Question :
(TCO 9) All of the following are true when a user creates their own
self-signed digital signature EXCEPT
Question 10
.
Question :
(TCO 10) ACCDE files
Question 11
.
Question :
(TCO 4) The term "cascading" refers to
Student Answer:
data changes travel from one table to another. data is put in sequential order.
queries can retrieve data at a faster rate. records are arranged in order.
1. Question :
(TCO 1) Designing a database often involves obtaining different perspectives from various sources to gather information. Discuss the importance of end user interviews in the data requirements gathering process.
Student Answer: Data modeling helps to understand the information
requirements. Data modeling differs according to the type of the business, because the business processes or each sector is different, and it needs to be identified in the modeling stage.
Initial step is the analyzing the situation, gather data. Data modeling process starts with requirement gatherings. When developing the proper data model it is important to communicate with the stakeholders about the requirements. Data modeling is the act of exploring data oriented structures. This can be used for variety of purposes. One of the important functions of data modeling is that, it helps to understand the information requirements. Especially this makes both developers and end users lives easier. As mentioned above, data modeling helps the end users to define their requirements, and the developers are able to develop a system to meet those specified requirements.
Question 2
.
Question :
(TCO 2) Explain the purpose of a conceptual database model and describe the most common method of creating one.
Student Answer: A conceptual data model is a summary-level data model that is most often used on strategic data projects. It typically describes an entire enterprise. Due to its highly abstract nature, it may be referred to as a conceptual model. Enterprise-wide coverage of the business concepts. Think Customer, Product, Store, Location, Asset. Designed and developed primarily for a business audience Contains around 20-50 entities (or concepts) with no or extremely limited number of attributes described.
Sometimes architects try to limit it to printing on one page. Contains relationships between entities, but may or may not included to the database. Designed and developed to be independent of DBMS, data storage locations or technologies. In fact, it would address digital and non-digital concepts. This means it would model paper records and artifacts as well as database artifacts.
Question 3
.
Question :
(TCO 4) Explain the terms entity and attribute. Describe an
example of an entity and then list two attributes. Using your examples, explain the data types that would be used to capture the attributes.
Student Answer: In clinical data, the entity is typically a clinical event, as
described above. In more general-purpose settings, the entity is a foreign key into an "objects" table that records common information about every "object" (thing) in the database at the minimum, a preferred name and brief description, as well as the category/class of entity to which it belongs. Every record (object) in this table is assigned a machine-generated object ID. The "objects table" is now standard in most large bioinformatics databases. The use of an objects table does not mandate the concurrent use of an EAV design: conventional tables can be used to store the category-specific details of each object. In the EAV table itself, this is just an attribute ID, a foreign key into an Attribute Definitions table, as stated above. However, there are usually multiple metadata tables that contain attribute-related information, and these are discussed shortly.
Question 4
.
Question :
(TCO 4) Explain 1NF, 2NF, and 3NF as related to database design.
Student Answer: The database utilized for the design for data entry. This makes it possible that all information is all input into individual table of categories. This makes it impossible for information to not be duplicated and do not repeat themselves. 1NF :As per 1NF, no two rows of data must contain repeating group of information.
In all, each table must be organized into rows, and each row should have a primary key that distinguishes it as unique. 2NF: As per 2NF, There must not be any partial dependency of any column on primary key. 3NF: As per 3NF,every non-prime attribute of table must be dependent on primary key. It removes the transitive dependency . Therefore, by noting all of the information if the 1NF, 2NF and 3NF make it possible to fulfill all of the information needed to complete the database. This is a very important contribution to make a report and get a clear table all of data. [Show Less]