1. Describe the types of data that Tarleton Gaming Solutions will need to store in their database.

The intent of this paper is to design and propose a database management system solution to Grandfield College for tracking software installed. I have analyzed the organizational issues and needs and developed conceptual, logical, and physical designs of DBMS solution. In order to implement the solution, substantial research had been done on best practices in design, available products, and the legal and ethical standards to which we must adhere during design. This paper includes Business rules, Conceptual, Logical, and Physical database designs, Recommendations on best DBMS required for Grandfield College, Data model, Legal

* As explained throughout this course, entity relationship modeling is a critical element of database design. If the database is not properly modeled, it is unlikely that the database will be properly developed. Using this knowledge, explain the key reasons why entity relationship modeling is important, and determine at least (1) way in which it impacts the overall development of the database.

2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and

Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models.

Campbell, R. J. (2015). Database Design: What HIM Professionals Need to Know. AHIMA. Retrieved from http://library.ahima.org/xpedio/groups/public/documents/ahima/bok1_024637.hcsp?dDocName=bok1_024637

One of the main components of a database is characters. Characters are letters, numbers and punctuation marks. You are using characters when you are typing a sentence for example. Another main component would be fields. Fields separate data in defined fields. When data is being entered even if you don’t have an answer for all fields a space is still left but it would be blank. If you have ever seen an excel spreadsheet that would give you an idea of how data is lined out into different fields. Records are a main database component as well. Records are a group of fields that are about one thing. An example would be social security numbers in a database of patients. Each patient would have a social security number and each social security number is in a field. That field would have the same information which is that patients social security number even though every ones is different and there would be many listed depending on how many patients was in the database. Gartee, R. (2011).

Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment:

Provides UML modelling for database designs, with the ability to represent the integration of data and application requirements through logical and physical designs

To implement a tool effectively, you should bring together engineers and database experts to design a good schema for your requirements data at the

Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.

ESL Inc. has tasked me with the project of finding a new database system that will better meet the needs of their growing customer base. ESL is a large company that has been using a series of spreadsheets and access databases, and manual records to track their business and they are currently looking for a better way to streamline the inner workings of their business. After evaluating their current system, it is apparent, that if a decision to move forward hadn’t taken place within the next few months, their current system would start to fail, as they are reaching capacity in memory used and bandwidth running the various individual instances of Access on their network.

If you understand SQL and relational databases, you will be able to use any SQL database

Storage requirements: - storage requirements is first and most important in designing. A great deal of thought go into examining the storage requirements. The physical size of the database, you have to consider the exchange development rate and data distribution requirements. There are some topic which are assessing current storage capacity:-

Type of Data: A data could be broadly classified in to three types viz. structured data, unstructured data and semi-structured data. Structured data are those which reside in a fixed field within a record or a file such as customer’s name, address, phone number etc. Unstructured data refers to information that is not organized in a pre-defined manner. Examples of Unstructured model include images, videos, word presentations etc. It is estimated that unstructured data occupies almost 80% of all available data in organizations. Semi-structured data are those that do not have a strict data model. For example, an email contains both structured data such as sender’s name, recipient’s name and subject and also unstructured portion such as attachments and body of the letter. (http://www.webopedia.com/TERM/S/structured_data.html).In an integrated, 3-tier architecture such data are handled by XML as data traverses through various layers via an Enterprise Service Bus (ESB).Thus, choosing a database requires the type of data to be taken in to consideration .

Storage requirements: - storage requirements is first and most important in designing. A great deal of thought go into examining the storage requirements. The physical size of the database, you have to consider the exchange development rate and data distribution requirements. There are some topic which are assessing current storage capacity:-