Which of the following is not an advantage of the usage of surrogate keys? A sur

Question

Which of the following is not an advantage of the usage of surrogate keys? A surrogate key is always guaranteed to be unique Surrogate keys are arbitrary and are not affected by changes in business rules We don't have to worry about updates to a surrogate key, since it never changes. Because surrogate keys are meaningless numbers, there is a tendency for duplicate records to get inserted. You are creating a database for a company that sells t-shirts. This company has multiple subsidiaries, which means that there data is stored on multiple databases (MS SQL Server, Oracle and DB2). You are selecting a data type for a column titles Price. Which of the following data types is the best fit? Big Int Decimal Money You are creating a small database for a jewelry store. You schedule a meeting with the owner to discuss the project and get an idea of what the database will require. The owner mentions how he would like the database to be shared on his network in the shop, produce numerous reports, include security and be visible on his website. Before you begin drafting your first model, you take a look at your schedule and realize that you may not have time to add the security and the web site visibility. What do you need to construct for the owner so that he knows what you are able to do and not to do with regards to this project? Scope Objectives Problem Statement Security Requirements

Explanation / Answer

solutions:

6. (c)we don't have to worry about update to surrogate key,since it never changes.

and

(d) because surrogate keys are meaning less numbers there is a tendency for duplicate records to get inserted.

7.(b) Decimal

8.(d) Security requirement

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.