This Competency Assessment assesses the following outcome(s):
IT163M1: Synthesize database concepts needed to effectively design a database.
GEL-1.02: Demonstrate college-level communication through the composition of original materials in Standard English.
PC-1.1: Engage in a team setting with professional integrity and respect.
You will be developing the competency of maintaining professional integrity and respect as you work on a project. You will work to create a logical model for the family reunion database. You will also apply normalization as you develop this logical model
Part 1
Scenario: You are going to be in charge of your family reunion this year, and you have decided to set up a database to hold all your family information. Before you begin developing the actual database, you need to do a bit of research. You need to find out what a relational database is and how to develop one.
As a database administrator, it is important to understand the conceptual nature of a relational database. Database administrators today continually research customer’s needs when designing and developing a database. This activity will help prepare you to conduct this type of research.
You will compose an essay that fulfills the following requirements:
Provide a detailed explanation to support your position. Be sure your essay demonstrates superior organization and is well-ordered, logical, and unified. Your essay should show no evidence of plagiarism, and you must cite at least two scholarly references to support your position. Follow all writing requirements, referring to Written Assignment Requirements for details.
Written work should be free of spelling, grammar, and APA errors, and contain no evidence of plagiarism. Follow all APA style guidelines, including properly formatted title and reference pages. Your paper must be at least two pages long, double-spaced, excluding the title and reference pages. Format your paper with 1-inch margins and 12- point font.
In your paper, you must demonstrate knowledge of a relational database. Your goal is to demonstrate to your professor that you understand what a relational database is.
Describe the six database objects available in Access and describe the five-step design method discussed in your reading.
The paper must be written in your own words. You are encouraged to read the assigned readings first to gain valuable insight for your paper.
Written work should be free of spelling, grammar, and errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion.
Instructions
Part 2
Scenario: You are going to be in charge of your family reunion this year, and you have decided to set up a database to hold all your family information.
Using VISIO (download from IMAGINE) or your favorite drawing program, you will create a conceptual model of your family database using Crow’s foot notation. Your Conceptual model must contain at least two tables.
Identify the entities and attributes for your conceptual model.
Identify the relationships between the entities.
You will compose a paper explaining why a high-level conceptual model is needed. Explain how you derived your conceptual model, a drawing of your conceptual model and an explanation of how you identified your entities and relationships.
Use APA format, which includes a title page, reference page, and at least 2 pages for the body of the paper. The paper must be written in your own words. You are encouraged to read the assigned readings first to gain valuable insight for your paper. If you elect to include some material from the Web, it must be properly referenced via APA standards.
Written work should be free of spelling, grammar, and errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion.
Part 3
You will create a logical model for the family reunion database. You will also apply normalization as you develop this logical model.
Instructions:
You will synthesize a logical diagram for the family reunion database using Crows Foot Notation. The model must be normalized to BNF3.
You will compose a paper that includes the following:
An explanation of how you derived your logical model.
List and explanation of the steps you took to normalize your logical model.
An explanation of how you identified your keys and relationships.
A drawing of your logical model.
Here are the paper requirements:
APA format which includes a title page, reference page, and at least two pages for the body of the paper.
The paper must be written in your own words. If you elect to include some material from the Web, it must be properly referenced via APA standards.
Written work should be free of spelling, grammar, and errors. Points deducted from the grade for each writing, spelling, or grammar error are at your instructor’s discretion.
Save your assessment as a Word document titled IT163_M1_Lastname.docx and submit to the Dropbox.
Checklist Rubric
Minimum Submission Requirements
This Assessment should be a Microsoft Word (minimum 2 pages for the body of the paper) document, in addition to the title and reference pages.
Respond to the questions in a thorough manner, providing specific examples of concepts, topics, definitions, and other elements asked for in the questions. Your paper should be highly organized, logical, and focused.
Your paper must be written in Standard English and demonstrate exceptional content, organization, style, and grammar and mechanics.
Your paper should provide a clearly established and sustained viewpoint and purpose.
Your writing should be well ordered, logical and unified, as well as original and insightful.
A separate page at the end of your paper should contain a list of references, in APA format. Use your textbook, the Library, and the internet for research.
Be sure to cite both in-text and reference list citations were appropriate and reference all sources. Your sources and content should follow proper APA citation style. Review the APA formatting and citation style found in the Writing Center (It should include a cover sheet, paper is double spaced, in Times New Roman 12-point font, correct citations, Standard English with no spelling or punctuation errors, and correct references at the bottom of the last page.).
If work submitted for this competency assessment does not meet the minimum submission requirements, it will be returned without being scored.
Plagiarism
Plagiarism is an act of academic dishonesty. It violates the University Honor Code, and the offense is subject to disciplinary action. You are expected to be the sole author of your work. Use of another person’s work or ideas must be accompanied by specific citations and references. Whether the action is intentional or not, it still constitutes plagiarism.
For more information on University’s Plagiarism policy, refer to the current University Catalog.
Professional homework help features
Our Experience
However the complexity of your assignment, we have the right professionals to carry out your specific task. ACME homework is a company that does homework help writing services for students who need homework help. We only hire super-skilled academic experts to write your projects. Our years of experience allows us to provide students with homework writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How our professional homework help writing services work
You first have to fill in an order form. In case you need any clarifications regarding the form, feel free to reach out for further guidance. To fill in the form, include basic informaion regarding your order that is topic, subject, number of pages required as well as any other relevant information that will be of help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download