Wednesday, 13 July 2016

Relation Database

·         Databases

You are the trainer for a major technology firm. One of the problems your firm has is hiring new technologists who have a fundamental understanding of relational databases. Therefore, you’ve been asked to create a database orientation
paper.
Write a four to five (4-5) page paper in which you:
1.    Describe what a relational database is and why relational databases are needed.
2.    Describe the process of normalization and why it is needed.
3.    Contrast and compare logical and physical database design.
4.    Critique SQL as a user-friendly query language.
5.    Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.
Your assignment must follow these formatting requirements:

·         Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
·         Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
The specific course learning outcomes associated with this assignment are:

·         Illustrate the use of information and communication technologies to solve problems as an information technology professional.
·         Use technology and information resources to research issues in information technology.
·         Write clearly and concisely about introductory information technology topics using proper writing mechanics and technical style conventions.


·         Input Controls
There are many kinds of input controls. Write a 4-5 page paper in which you:
·         Explain the function of input controls.
·         Identify four (4) types of input control and explain the function of each.
·         Provide an example of a data integrity error that could occur if each of these types of input control were not in place.
·         Explain the advantages and disadvantages of restricting user interfaces. (User interfaces can often be restricted, limiting the user’s ability to navigate to other areas of the system, or out of the system.)
·         Design and build a graphical representation of a Web-based input for making a hotel reservation, using Visio or PowerPoint or an equivalent.
·         Research and cite at least three (3) reputable academic sources.
Your assignment must:
·         Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
·         Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
·         Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the Word document before the paper is submitted.
The specific Course Learning Outcomes associated with this assignment are:
·         Design high-level logical system characteristics (user interface design, design of data, and information requirements).
·         Use contemporary CASE tools in process and data modeling.
·         Use technology and information resources to research issues in systems analysis and development.
·         Write clearly and concisely about systems analysis and development using proper writing mechanics.


No comments:

Post a Comment

Leadership Trends in Common Wealth Bank

Overview of Common Wealth Bank of Australia Commonwealth bank of Australia is one out of four largest integrated financial institutions. T...