Assignment: CS Making Business Decisions II
You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
PROJECT FOCUS:
Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze
…show more content…
Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
PROJECT FOCUS:
Once you understand the benefits associated with a relational database you decide to build a small database to help you track and analyze customer orders and sales information.
Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.
For this assignment, you will NOT create a database. You will list the type of data you want to collect, group it accordingly, break it into field and determine attributes. Think about how the different pieces of data relate to one another and what purpose they serve. You may use Excel, Word, or Visio for this assignment.
Assignment: CS Making Business Decisions II
You understand that database technology can dramatically improve your ability to analyze information, compared to spreadsheet technology, and assist you in developing your strategic plans for the cafe. To help you familiarize yourself with databases and their associated business value you need to create a report detailing the basics of databases and why they are better for running a business than spreadsheet applications. Be sure to provide a detailed explanation of relational databases along with their associated business advantages.
PROJECT
Question 1: Describe two effects of database tools and technologies on business performance and decision making.
Review each database or collection to gather information to create a description for the assignment. Each description must:
It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal things. This is the relationship between the primary key and foreign key. Ians & Co will benefit with a relational database as it has many links to primary and secondary data. Ians & Co being a large company will have a lot of data which means it will be harder to maintain with a simple and old database.
* Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.
The lab begins with a simple example of query development using Access; then, evolves to more complex queries which the student should perform after completing the first exercise. The student can create a query with the wizard, with query design view, or with SQL statements. The Northwind database will be used again in this lab.
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.
Read the textbook. Do research on databases. All answers should be analytical, using IGEA and MLA. Please use own words/original thought, not regurgitation of facts. This is the expectation all year.
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
Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is
Business corporations often require summarized pieces of data in the form of pivot tables for efficient and strategic decision-making. However, the use of pivot tables poses certain data storage problems especially in the light of the need to have the formulas stored with data. This paper presents one data storage situation where using pivot tables for summarizing data was unsuitable because the storage was done using a Microsoft Excel Spreadsheet, stored in XLS format. The project purposes to implement the data storage using a database management system, in this case, Microsoft Access to address the problem
One size fits all. The developers go to for all data. You need only a relational database. This is the false assumption that you will see when it comes to database models. The relational database model is great for data that normally can fit into a table, or shows relationships between data, but not all data falls into that category. There are a few options for these situations. You can use an object-oriented database, a hierarchical database, a network database, and a flat-file database.
The relational database does have some drawbacks. For example, it may take more time to search for data than some other methods (Heberling, 2008). The relational database would not be the best option if the application used with the database required a special data topology (Stephens, 2009). Suri and Sharma (2011) found that, though the relational database has
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.
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images (Rouse, n.d.). Prior to this class I really never worked with any type of database software before. I have always wanted to learn about using Access and explore to features it had but I never accomplished that before. In my prior school I had the basic computer classes. I taught myself Excel and Word and those classes built on what I had learned to the point where all my finances in the house and bills, etc. are on spreadsheets and all I have to do is input the information and the sheet does the rest.
1. How does a relational database organize data, and how does it differ from an object-oriented database?