Relational Database : Assignment : 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

A relational database is a database that consists of a collection of tables with columns showing entities, and rows showing data. This type of database uses a primary key and foreign key. The foreign key in another table will point to the primary key of a table, and this is how tables can relate to each other. This permits for one-to-one, one-to-many, and many-to-many relationship between the data. An advantage of relational databases includes the ease of adding or modifying new tables and entities without needing to change the structure of the database already in place. Relational database have many features, including indexing, setting data type, and setting validation tests, all these help to ensure data integrity.

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.

* Describe the role of databases and database management systems in managing organizational data and information.

Databases are the heart of the company. This is where all crucial company information is stored and can be accessed. Some databases are stored on site others in remote locations or using clouds. The information within a database can be manipulated in any way that the company needs it to be. Databases help to quickly search and retrieve information, it saves from data redundancy.

Relational data is when you can put data in a computer one time and it grows

Sue, I still cannot get into the older Db but, I did a looked up on the current CDU Db that started in May 21 2011. I only found 1 EL-15 # 51796 that is close to the request with street light issues.

3. What would you recommend as effective methods for this organisation to store the data, and why? (Give two different options)

Marina, I enjoyed reading your post. I think the reason why a person’s age and health affect their premiums is because if a person health is poor, it carries a higher risk (gamble) versus a person in good health. A majority of the insurance company also bases a person’s premium on whether he or she smokes or not. Again, I enjoyed reading your

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.

This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS.

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.

“A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.” (tech-faq.com) To be useful over a long term the database should be able to store all the records necessary for the business to function as well as be able to get all of this information back in case of a system failure or a crash. If all the information is loss a business could go bankrupt so the database is a fail

This video I watched “Should Pot be Legal?”, brought up some really good points about the legalization of marijuana and it showed both sides of the argument. There was two people back and forth debating if marijuana should be legal or illegal. Hutchinson was against legalizing marijuana and Ethan Nadelmann was for legalizing marijuana. As it goes for me I agree with Ethan Nadelmann, I think that medical marijuana should definitely be legal and people should be regulating it. A great point was brought up that marijuana has been proven that it helps people with severe medical conditions, for example it has been a huge success for people with arthritis.

1.) At this moment, I believe I currently possess a leadership ability that allows me to switch in and out of a leadership role when necessary. I feel as if I know the right moment where I need to step up and be a leader and when I also need to step back and let somebody else take charge. I possess the ability to be extremely organized, I have a strategic system for everything. I categorize