Assignment 1
Database Environment Memo As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standards.
Write a 2 page memo (using Memo Template) in which you do the following:
Choose a database environment from the following:
An appropriate database environment within your workplace (must be approved by your instructor)
An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum
Smith Consulting (Virtual Organization) - needs a database to track their consulting staff, each staff member's skill sets, and what projects they are working on
Analyze the database environment.
Describe the problems and constraints.
Describe the objectives of the database environment.
Describe the scope and boundaries.
List the data specifications (must include a minimum of three entities with attributes).
Include 3 to 5 references.
Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments.
Assignment 2
ERD Creation Project The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.
Use a Microsoft Visio diagram to create a detailed ERD using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty's feedback.
Use a Microsoft Access database to create the preliminary database tables, columns with data types, primary keys, and relationships.
Individual Normalization of the ERD The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.
Your database project must meet the following assessment requirements:
Design and develop a database using professional principles and standards.
Provide a logical and physical design of the database.
Use relational database software application to develop database.
Provide an entity relationship diagram.
Normalize the database.
Generate and provide test data.
Use a Microsoft Visio diagram to normalize the ERD to third normal form (3NF).
Use the Microsoft Access database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.