ZuoTi.Pro
Question

when you establish a relationship between a primary and foriegn key, the dbms can enforce integrity...

when you establish a relationship between a primary and foriegn key, the dbms can enforce integrity constraints? true or false

what database key links one table to another?

what data base function allows you to define the data your database is storing?
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

When you establish a relationship between a primary and foriegn key, the dbms can enforce integrity constraints

Answer : True

what database key links one table to another?

Ans : Foreign key

what data base function allows you to define the data your database is storing?

Ans : SELECT function

Please leave a like. Thank you.

0 0
Add a comment
Know the answer?
Add Answer to:
when you establish a relationship between a primary and foriegn key, the dbms can enforce integrity...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Database Design and Management: The percent sign (%) and asterisk (*) symbols can be used with...

    Database Design and Management: The percent sign (%) and asterisk (*) symbols can be used with the LIKE comparison operator to create a search pattern. True or False? When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. Assuming you are implementing an Exclusive Design, you must also create two Unique Key Constraints to ensure the Arc is implemented correctly. True or False? The explanation below is a User Defined integrity rule...

  • QUESTION 1 What is the most common relationship within a relational database? Select the best answer...

    QUESTION 1 What is the most common relationship within a relational database? Select the best answer from the following. One-To-One relationship. o One-To-Many relationship. Many-To-Many relationship. Zero-To-Zero relationship. QUESTION 2 What is an "entity'? Select the best answer from the following. An entity, for our purposes, is the same as a table in the database. An entity represents one of the columns in an individual table. There are no entities in a relational database. Entities are only part of NoSQL...

  • True or False questions: 1. A data type mismatch error would occur when the primary key...

    True or False questions: 1. A data type mismatch error would occur when the primary key data data type is auto number and the foreign key in the related table is number. 2. The data type long integer is the same as integer. 3. When using SQL, the SELECT clause isolates tables in the database. 4. A Referential Integrity violation occur when the primary key is null. 5. When an REA model has 7 entities ,2 linking tables, 3 Resource...

  • 6. With respect to database systems, which of the following statement(s) is (are) true? a. The...

    6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....

  • 16. The primary key is selected from the: Group of answer choices composite keys. foreign keys....

    16. The primary key is selected from the: Group of answer choices composite keys. foreign keys. candidate keys. surrogate keys. 17. "Delete Table" statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table. Group of answer choices True False 18. Which of the following commands always affect one row at a time when it runs? Group of answer choices Drop Insert Delete Update 19. Data stored as an image...

  • erms Matching Match the key terms with their definitions. Write the key term letter by the...

    erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent...

  • To be in the third normal form, Hint: In order to in 3NF you must first...

    To be in the third normal form, Hint: In order to in 3NF you must first have attained 1NF and 2NF so all of the above is the correct answer. In the database design world the saying is that to be completely normalized the data be represented "by the key, the whole key, and nothing but the key so help me Codd". Ted Codd was the person behind the development of the relational theory back in the 1960s and 70s....

  • The employee is table, the best candidate for primary key is Select one: a. Department ID...

    The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...

  • You are designing a table for employee data of a company. You have a requirement to...

    You are designing a table for employee data of a company. You have a requirement to identify if an employee is a United States citizen or not. You have designed a table called EMPLOYEE to store information related to each employee and you have a column called US CITIZEN INDICATOR to store if an employee is a US citizen or not. You only want to store values "Y" or "N" in this column. From the following options, what is the...

  • 21. What are some questions you can ask as a nurse when assessing the bone integrity?...

    21. What are some questions you can ask as a nurse when assessing the bone integrity? 22. How is joint function evaluated? 23. What is the difference between contracture an effusion? 24. How is the muscular system assessed? 25. What are some ways to assess the peripheral nerve function? 26. What is the difference between X-rays, CT scan, and MRI? 27. What are some Nursing interventions that done before getting a X ray, CT scan or MRI? 28. What is...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT