QUESTION
BIS245: 6 Discussion
Questions
Please answer each of the 6 questions Individually. There is no specific length
requirement for responses to each question. However, they must be quality responses. Must
list any and all references per question in APA format.
1. Why do you think organizing
data into tables and relationships is a good way to design a database? How do
related tables improve the accuracy of data in a database?
2. Give examples
of ERDs showing cardinality.
3. Entity Integrity, Referential Integrity: Please define
these two very important terms with examples.
4. Describe some typical pairs of entities that you think
might be common in business, and describe their relationships, whether
many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think
that a particular relationship applies to that pair of entities.
5. Refer to the list below of the possible SQL clauses below
and ask you for input as to how and why we use each.
SELECT clause
FROM clause
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
SANTA clause
6. Discuss the role of VBA (Visual Basic for Application) in
view of the Microsoft Office suite of products.
ANSWER:
Place an order in 3 easy steps. Takes less than 5 mins.