A small surgery center needs your help to create a database.

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments.

• Please identify the attributes and primary keys needed for each of the entities.
• Identify the data types you would use for each of the attributes.
• Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
  • Use the ER matrix to determine the relationships.
• Create an ER diagram using Visio based on your analysis.
• Identify all foreign keys needed in the database design.
• Create the database in Access and populate the tables.
• To use the database as the main office application, what other entities and attributes might be needed?

NOTE: The Case Study is an individual project.

Due Week 5

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments.

• Please identify the attributes and primary keys needed for each of the entities.
• Identify the data types you would use for each of the attributes.
• Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
  • Use the ER matrix to determine the relationships.
• Create an ER diagram using Visio based on your analysis.
• Identify all foreign keys needed in the database design.
• Create the database in Access and populate the tables.
• To use the database as the main office application, what other entities and attributes might be needed?

NOTE: The Case Study is an individual project.

Due Week 5

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments.

• Please identify the attributes and primary keys needed for each of the entities.
• Identify the data types you would use for each of the attributes.
• Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
  • Use the ER matrix to determine the relationships.
• Create an ER diagram using Visio based on your analysis.
• Identify all foreign keys needed in the database design.
• Create the database in Access and populate the tables.
• To use the database as the main office application, what other entities and attributes might be needed?

NOTE: The Case Study is an individual project.

Due Week 5

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments.

• Please identify the attributes and primary keys needed for each of the entities.
• Identify the data types you would use for each of the attributes.
• Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
  • Use the ER matrix to determine the relationships.
• Create an ER diagram using Visio based on your analysis.
• Identify all foreign keys needed in the database design.
• Create the database in Access and populate the tables.
• To use the database as the main office application, what other entities and attributes might be needed?

NOTE: The Case Study is an individual project.

Due Week 5

• Upload completed Visio Conceptual Design.
• Upload completed Access database file
• A 3-5 page APA paper discussing the following topics:
  • Discuss Database impact on the workplace,
  • Discuss database benefits when businesses use querie,
  • Forms, and reports.
  • Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.
  • A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments.
  • Please identify the attributes and primary keys needed for each of the entities.
  • Identify the data types you would use for each of the attributes.
  • Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
    • Use the ER matrix to determine the relationships.
  • Create an ER diagram using Visio based on your analysis.
  • Identify all foreign keys needed in the database design.
  • Create the database in Access and populate the tables.
  • To use the database as the main office application, what other entities and attributes might be needed?
  • NOTE: The Case Study is an individual project.
  • Due Week 5
  • Upload completed Visio Conceptual Design.
  • Upload completed Access database file
  • A 3-5 page APA paper discussing the following topics:
    • Discuss Database impact on the workplace,
    • Discuss database benefits when businesses use querie,
    • Forms, and reports.
    • Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.