Reference no: EM131267452
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.
Determine the security and networking issues associated
: Take a position on the idea of IPv6 being hailed as the next generation of the Internet. Support your response with evidence or examples. Critique the adoption and deployment of IPv6, and determine the security and networking issues associated with..
|
What role do parents and teachers have in placement
: What are the indicators of exceptionality a classroom teacher should look for when a student also has a language barrier - How can informal as well as formal assessment results factor into placement?
|
Record the price and the volume of each brand
: Before going any further, rank the brands according to which you think is the highest ? Record the price and the volume of each brand.
|
Create a trivia game for two players
: Starting with player 1, each player gets a turn at answering five trivia questions. (There are a total of 10 questions) WHen a question is displayed , four possible answers are also dislayed. Only one of the answers is correct, and if the player s..
|
Design and develop a database using professional principles
: 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.
|
Find the error probability for an fh spread spectrum signal
: Repeat Problem 12.19 when fast frequency hopping is performed with L hops per coded bit and the decoder is a hard-decision Viterbi decoder. The L chips per coded bit are square-law-detected and combined prior to the hard decision.
|
Compare and contrast distance-vector and link state routing
: Routing and Switching Selection Criteria. Please respond to the following: Compare and contrast distance-vector and link state routing, and analyze the limitations that would prevent the usage of each.
|
How the definition of strategy fits
: Define strategy and examine how the definition of strategy fits your chosen company and its situation. Support your response - Summarize the main strategies that your chosen company's management took leading up to this company's recent development.
|
What is the company vision statement
: Write a 350- to 700-word paper in which you address the following: What is the company's mission statement? What is the company's vision statement? What role do these have on the way the business operates
|