Purchase Solution

Scope of Database Administration and Normalization

Not what you're looking for?

Ask Custom Question

Please see attached file for full problem description.

I need help answering the following database questions:

1. I'm to provide a concise, but complete, written description of what functions are included within the scope of data administration, and make a case why data administration is unique from traditional information systems and database functions. Also to provide one or more samples of an organization chart showing the "fit" and relationship of a data administration function in an organization, including a description of how organizational chart of data administration function relates to and supports traditional IS and database functions and indicate to whom does the data administration function should report.

2. Reviewed the data model below and correct to a normal form. Developing a report listing the problems with the data model below and provide a correct data model and an accompanying data dictionary for the system based on the information about the system characteristics given below. (NOTE: This is a small database. DO NOT put in any additional information or data elements not identified in the specifications below).

Data Model

The system functionality is suppose to include:
? Ability to input new client information including
o Last, first, and middle name
o Date of Birth
o Gender
o Current Address
? Ability to update client information
o Last, first, and middle name
o Date of Birth
o Gender
o Current Address
? Ability to input client appointment dates
o Date of visit
o Time of visit
o Practitioner
? Ability to update client appointment dates
o Date of visit
o Time of visit
o Practitioner

The system also needs to be able to generate the following reports:
? List of all clients
? List of appointments by client
? List of appointments by date

Attachments
Purchase this Solution

Solution Summary

This solution analyzes the scope of database administration and also takes an in depth look at Normalization and various normal forms.

Purchase this Solution


Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.