Synthesize database concepts needed to effectively design a database.

This Competency Assessment assesses the following outcome(s):

IT163M1: Synthesize database concepts needed to effectively design a database.

Don't use plagiarized sources. Get Your Custom Essay on
Synthesize database concepts needed to effectively design a database.
Just from $13/Page
Order Essay

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.

Grab 16% Discount On This Paper
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

ACME Homework provides the best top-grade academic writing services in compliance with our customers’ instructions. Have your paper written by a certified professional online college homework help writer to produce only high-quality essays with zero plagiarism.

Professional Academic Writers

You can now choose from a pool of online college homework help writers. Choose your writer and have them write the best content for you. ACME Homework has, over the years, secured a team of the most reliable, experienced, and qualified writers. You can, therefore, trust that your assignment is in good hands.

Affordable Prices

We know that students have very limited budgets. And for that, we always strive to provide only the best, most affordable online college homework help services to our customers. Our goal is to provide top-quality assignment help services to all customers at the lowest, most affordable prices.

On-Time delivery

At Acmehomework.com, we pay strict attention to deadlines. We recommend you to check out clients’ reviews for assurance that we will complete your assignments within the set deadlines. You can, therefore, trust that your paper will be done within and before the set deadline. Until now, we have not missed a single deadline.

100% Originality

Our Acmehomework.com homework helper experts write only 100% original and plagiarism-free content for all of our clients. We also have a Quality Assurance Department team that goes through all work submitted by our writers multiple times. You can, therefore, rest assured that any signs of plagiarized or unoriginal content will be rejected before it reaches your portal.

Customer Support 24/7

Acmehomework.com expert writers are always available 24/7 for customers who need assistance with using our website. You don’t have to check your watch the next time you want to have your assignment written. Our customer support is always available round the clock and ready to listen to your queries. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

Grab 16% Discount On This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

For years now, Acmehomework.com has stood as a leader in providing its customers with the best online college homework help service in the industry. And all you have to do is provide us with the details of your order. Leave everything else to us. We’ve always got you covered.

Essays

Essay Writing Services

Since we launched, Acmehomework.com deserved the best online “college homework help status” thanks to our essay ordering, writing, and delivery process. We deliver nothing but excellence in our results. Our essay writing services include impeccable grammar, zero-plagiarism, proper structure, and conformance to guidelines.

Admissions

Admission and Business Papers

Our top-quality online college homework help services guarantee that you will be accepted into your desired university. You just need to fill out your admission and business papers, and our team of online homework help workers will handle the rest. We will help you achieve and secure the best positions in your admissions forms.

Editing

Editing and Proofreading

At Acmehomework.com, we have a skilled writing and editing team that’s dedicated to creating, editing, and restructuring for all types of papers. Our online college homework help editing and proofreading team will check, paraphrase, and correct any grammar mistakes on your paper before submitting the final document to you.

Coursework

Technical Papers

At Acmehomework.com, we pride ourselves in having writers in almost all fields, even the most technical ones. You never have to worry about your paper being too technical for our certified online college homework help writers to handle. ACME Homework’s team of writers can handle even the most complex writers. We will match your paper to the most competent writer that we believe will handle your paper the best way possible.

                                                                                     Place Order