First, you must choose a database environment from the following choices:
A college that needs to track courses, course sections, and professors teach the sections in order to publish a course schedule
A retail business that needs to track store locations, shifts, and the employees assigned to each shift
An appropriate database environment within your workplace (must be approved by your instructor - send me a one-paragraph email describing the environment and its purpose)
You may NOT use examples involving:
An art museum that needs to track artists, artwork, and locations
A consulting organization that needs to track staff, skill sets, and projects
Once you have chosen your database environment, write a 750- to 1,050-word paper in which you address these elements:
Analyze the database environment, including its objectives (why will it be built?), its boundaries (what is in and out of scope?), its constraints (what rules must it follow?), and any challenges that will accompany its construction.
Describe at least 3 entities (which will eventually become tables in a database)
List attributes for each of these entities.