What is the difference between a record and a field

Assignment Help Database Management System

Reference no: EM132350431

Database Assignment -

Part A - Questions

1. Describe the term database.

2. What is a field?

3. What is a record?

4. What is the difference between a flat file and a relational database?

5. What is the function of a query?

6. What is the function of a report?

7. What are some advantages in using an electronic database?

8. Name two ways to conserve resources in the office

9. List two advantages of recycling paper in an office environment? (apart from saving trees)

10. List three workplace health and safety symptoms.

11. Name four object types that are found in the database window?

12. What is the difference between a record and a field?

13. What is a relational database?

14. List two ways to move to the last record in a datasheet?

15. How do you select an entire record in a database?

16. How do you move from field to field in a table?

17. What is a primary key? Why do you include a primary key in a table?

18. How do you define a primary key for a table?

19. List three common data types that can be used when creating a table?

20. What criteria would you use in a query to find items manufactured after 1990?

Part B - Case Study

1. What would the reporting milestones have been? How many lodgements did the department expect to receive?

2. What evidence was required to lodge data at each milestone? Initial? Midpoint? Completion?

3. What outcome codes would you have reported for each unit at completion?

4. What dates would you have reported for each unit at completion? Training contract start and end dates? Training plan start and end dates? Actual start and end dates?

5. What is the difference between the Withdrawn and Competency not achieved/fail outcomes? When would you use each?

Part C - Project

Create a database called METRO TOURS which contains details of tours run by your company. You are required to create the following tables, setting appropriate data types.

Reference no: EM132350431

Questions Cloud

Describe two interventions that would be used and why : How would a Milan-style therapist approach the current presenting problem? Identify and describe two interventions that would be used and why.

What are the principal sources of of excessive nitrate : What are the principal sources of of excessive nitrate and phosphatebin rivers and lakes

Project required on rust programming language : PROJECT REQUIRED ON RUST PROGRAMMING LANGUAGE - Totally in rust programming language, no mixing of languages

How will you assist family members in adopting strategies : You are now in the fourth session with the Robertson family. Dan, Marie, and Peter have all recognized how they contribute to the family problems.

What is the difference between a record and a field : What is the difference between a record and a field? What is the difference between a flat file and a relational database? Describe the term database

How do your practices align with practical guidelines : Discuss some practical ways that you practice self-care. How do your practices align with practical guidelines for self-care recommended by other psychologists?

Describe how you might apply the specific skills : Describe how you might apply the specific skills and techniques of the chosen intervention. Briefly explain how you could measure the outcomes.

Briefly describe corporate social responsibility : Post by Day 3 an assessment of how corporate social responsibility (CSR) influences ethical behavior. Your assessment should include the following.

Does the model meet all of the assumptions : Run diagnostics for the regression model. Does the model meet all of the assumptions? Be sure and comment on what assumptions were not met and the possible.

User Account

All Pages