Reference no: EM13276523
True or False:
Q1: An inner join creates a result (view) from matching criteria ____
Q2: Foreign keys go into the strong entity ____
Q3: The process of data modeling may produce an ER diagram ____
Q4: SQL is the standard language used to access a relational database ____
Q5: ERD is the modeling process used to eliminate anomalies from a relational database _____
Fill in the Blank:
Q6: A main characteristic that distinguish relational databases from a data warehouse is: ______________________________________________.
Q7: A relational database is in _____________ normal form when the transitive dependency anomalies are removed.
Q8: A technique and notation used to diagram a relational database model using the Semantic Modeling approach is: ____________________.
Multiple Choice:
Q9: A mechanism that ensures the deletion of all related data among multiple tables when a record is removed is called:
____ A. Join
____ B. Referential Integrity
____ C. Modification Anomaly
____ D. Two Phase Commit
Q10: The process used to define entities (tables) and their relationships is:
____ A. Metadata definition
____ B. Modeling
____ C. UML
|
Direct measurement of time-temperature history
: Direct measurement of time-temperature history during microwave heating is generally obtained by fiber-optic sensors and not by metal probes ?
|
|
Pepsi''s global strategy
: Mike Doyle, creative director at Arnell Group, explains that there was a great depth of exploration and research that was conducted before even beginning to formulate a new Pepsi packaging strategy. PepsiCo and Arnell Group traveled extensively to em..
|
|
Calculate the payback period-net present value
: Calculate the payback period. Calculate the net present value. Calculate the accounting rate of return
|
|
State-of-the-art technology-daily demand-optimal lot size
: Frankfurt Electronics produces a component internally using a state-of-the-art technology. The operations manager wants to determine the optimal lot size to ensure that the total annual inventory cost is minimized.
|
|
Foreign keys go into the strong entity
: An inner join creates a result (view) from matching criteria. Foreign keys go into the strong entity. The process of data modeling may produce an ER diagram
|
|
Escherichia coli is type of bacteria
: Escherichia coli (E.coli) is a type of bacteria that, depending on the strain, either lives in the human digestive tract without any adverse effect or causes severe illness in humans.
|
|
Disadvantages of cloud-based hosting and in-house hosting
: Explain the advantages and disadvantages of cloud-based hosting and in-house hosting. Explain the three factors that have made cloud computing possible today.
|
|
Contrast neutron star and white dwarf-messier catalogue
: Contrast a neutron star and a white dwarf. Contrast interstellar reddening and extinction. What is the Messier catalogue? Describe the evolution of a nova system. What are the two kinds of supernovae? Describe how a pulsar works.
|
|
How lack of foresight led to harm for an organization
: Research a contemporary example (in the last 5 years) of how foresight benefited an organization or how lack of foresight led to harm for an organization. If foresight was helpful, identify the reasons why.
|