Reference no: EM131081762
Your first step is to select a database you will design and implement. You will write a report describing the database design development life cycle and describe in details the steps needed to properly create the database you have selected for your Key Assignment. You will also provide an overall description of your database.
You also should take this opportunity to create the template for your entire Key Assignment project; create a Word document that you will add to for each remaining assignment. The document should follow this format:
- Database design project document shell
- Use Microsoft Word
- Title page
- Course number and name
- Project name
- Student name
- Faculty name
- Date
- Table of contents
- Use auto-generated TOC
- Separate page
- Maximum of three levels deep (one level deep is okay too)
- Be sure to update the fields of the TOC so it is up-to-date before submitting your project.
- Section headings (create each heading on a new page with TBD as content except for sections listed under new content below)
- Project outline
- Description of the database design life cycle
- The entity relationship diagram
- The logical model and normalization
- The Microsoft Access database
- The Microsoft Access database application
Add the selected database project description under the section titled: Project Outline.
Add the discussion about the database design life cycle and steps involved in database development to the section titled: Description of the Database Design Lifecycle.
The deliverables for this task should include the following:
- A listing and description of the 7 steps of the SDLC/DBDSL.
- Describe the specific tasks that should be taken at each step in the database development for your selected database.
- A description of the 3 steps in database creation (including conceptual, logical, and physical data modeling) as it relates to your selected database.
Once requirements analysis is completed, the first step in database design can be completed. This step is the conceptual model (or entity relationship diagram). Using any modeling tool you choose (MS Access, SmartDraw, Visio, Erwin, or even PowerPoint or Word), create an entity-relationship diagram (ERD) from the entity and attributes list for the database project you selected similar to what you did in the Discussion Board this week. Your submission should ensure the following:
- All entities and attributes are identified
- All relationships between entities are defined (including proper relation semantics)
- Add your ERD as a screenshot from the template started in Week 1, and provide supporting discussion about how the relationships were established and determined.
- Add the ERD and discussion to the section in your template titled: The Entity Relationship Diagram.
- Update the TOC to reflect the new section.
Full and partial-mesh topologies
: Compare and contrast full and partial-mesh topologies. What advantages does a partial mesh have compared to a full mesh?
|
Analysis of macroeconomic settings
: ACCG350 -GROUP MAJOR ASSIGNMENT INSTRUCTIONS. A clear statement of the company's activities. Analysis of macroeconomic settings, and an assessment of their impacts for the company being value. Students may include analyses of other macro-level factor..
|
What is the pmf px (x)
: If p = 0.2, what is the probability that the child will throw the Frisbee more than four times?
|
Examine fictional case study of the people bank of bradbury
: Examine the fictional case study of the People's Bank of Bradbury (found in the Module Two Resources folder) and describe the problems and issues therein. Discuss how the leader's style and approach could have led to the problems experienced by th..
|
Overall description of database
: Your first step is to select a database you will design and implement. You will write a report describing the database design development life cycle and describe in details the steps needed to properly create the database you have selected for yo..
|
What is the pmf of k
: What is the PMF of K, the number of fish that are hooked on a single cast of the line?
|
Goals and objectives for this departmental lan
: Identify at least 5 security controls and counter measure that can help achieve CIA goals and objectives for this departmental LAN
|
How many losers did you have after d - 1 days
: Let D be the number of the day on which you buy your jth losing ticket. What is PD(d)? you buy your jth losing ticket on day d, how many losers did you have after d - 1 days?
|
Knowledge of access controls and public key infrastructures
: Using your knowledge of access controls and Public Key Infrastructures (PKI), align and apply a solution for handling PKI and key management for a large enterprise with many remote users and workers.
|