Basic Database Design Concepts

Each assignment uses material from the previous assignment, so you will be creating a database in Chapter One, Asking it Questions in Chapter Two and then making changes in Chapter Three. You will only need to create it once and use it over and over again.

Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.

* Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Hierarchical database have data in a tree like structure with a parent to child relationship (one-to-many). The parent could have many children but the children have only one parent. All the attributes of the data is in a list under one entity type.

This must be in your own words and not copied and pasted from the original source. Include the purpose of the database and the subject matter it covers. This may be four or five sentences; and

Database model defines the logical structure of the database by determining manner in which the data will be stored. Relational model is one of the most popular database models, which defines tables and relationships between the tables.

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.

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).

Using the tables from Task 1, design and implement suitable data entry forms which incorporate features to ensure the validity and integrity of data. You must include the following:

In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables, Entity –Relational Diagram (ERD), establish connection to your local MySQL Server, create physical database and insert data to the tables.

A one to one relationship in a database is where each row in a database is linked with another database. Only one can be linked with another from another table. For example in Table A and Table B, each row in Table has to be linked with another row in Table B. In each of them, they must have the same number of rows, otherwise it won’t work. This does make it sound like you could just merge the two tables into one, which in theory is true. But the advantage of having two separate tables is that if you have columns of data that you don’t often use then you can separate them into another table. This will make information in the primary table easier to read as it will only have the relevant information in it.

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:

Firstly a relational database contains a set of tables which basically are linked collectively by the relationships between the tables. Also it is also known as reason such as a database is called relational database.

I am using one for a social network I am creating. It is very complex. I am still working on how the database should work. Once I have figured this out, I will create the database. After I create the database, I will create an interface, and then style it. SQL is simple to learn, creating the logic to create a user-friendly and efficient database is more complicated.

The reasons why various organisations use databases are because databases can be used to improve productivity. The term ‘productivity’ basically means the “average measure of the efficiency of production”. For example this can be done by “collaborative working”. The term “collaborative working” means “the act of two or more people or organizations working together for a particular purpose”, this definition I received off a website named ‘http://dictionary.cambridge.org/’. My own definition of “collaborative working” is when people work as partners for a fixed time to fulfil a specific purpose. Collaborative working improves productivity in databases, as by working as partners you are sharing and receiving different kinds of information, so this