Relational Database Paper

Improved Essays
Before some of the advancements in technology, all records of information was saved and filed in cabinets for a specific amount of time before they were disposed of. Now most information will be kept within a database. A database is a group of records that comprise of people, places, or things. An example of a paper-based database is a telephone book. A telephone book has information of phone users in a specific location. Each user is listed by name, address and number. The listed information is the same for a business. A business organizes data in a relational database. The relational database consists of data the business needs to be operational. Relational databases split data into two-dimensional tables as entity and attributes. Every level of the …show more content…
In my experience as a logistician, we rely on suppliers on hand inventory to make sure our warehouse and assemblages are fully stocked. If they weren’t able to meet that fulfillment we would find someone else that could even last minute because anything could happen in a short notice. I would assume that the response would be the same in the IT field. Now we have a starting database that has a list of everything that we need for our business the next step would be to create a database management system (DBMS) so we can use the data in the best way possible. Instead of looking at an endless list of records the (DBMS) allows the end users to create their own view to get only the information they need which is called data manipulation language. The data manipulation language use today is Structured Query Language (SQL). SQL is the tool used in DBMS to extract data to the users’ request. Like I said before once the user identifies all the supplies they need in the database the products are purchased and shipped to the customer creating a business relationship with the two. As time progress, a business can use the information in their database to increase productivity and make better

Related Documents

  • Decent Essays

    Nt1330 Unit 1 Study Guide

    • 573 Words
    • 3 Pages

    Database management system (DBMS) – is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze data. Offers timely, interactive, and flexible data access. 12. Scalability – which means that a system can be expanded, modified, or downsized to easily meet the rapidly changing needs of a business enterprise. 13.…

    • 573 Words
    • 3 Pages
    Decent Essays
  • Decent Essays

    Pt2520 Week 2 Assignment

    • 517 Words
    • 3 Pages

    This week we learned lots about the decomposition of our relations we are creating in the database as well how to make the relations into normal forms, which there are three normal forms. I learned that there can be data that is redundant and therefore not useful for the database. This data has no integrity and can be misplaced and even confuse how the data can be used and retrieved. This type of problem must be avoided. I had a hard time understanding how the breaking down of one relation into two or more would help keep all the data from being redundant.…

    • 517 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    College to Career: A recent survey commissioned by Bentley University in 2014 found that “compared with business decision-makers and corporate recruiters, high school and college students were far less likely to define preparedness in terms of personal traits or work ethic” (Chase, 2015). This means skills and experience rank high for college students when they evaluate preparedness. Unfortunately, the same survey found “thirty-seven percent of recent college graduates give themselves a grade of “C” or lower on their individual level of preparedness” (Chase, 2015).…

    • 899 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Target Corporation enhances its information warehouses with latest big data that is technologically sophisticated to crunch large data using complex algorithms and provide vital output data for a daily operation as well as strengthen its capabilities over its rival which is a competitive advantage and speed up worker productivity. A quality tracking tool provided by an information system tracks each package, parts ensuring the goods meet the quality standard. Target Corporation allocated large budget to upgrade the information system as part of a roadmap to transform business (Target Roadmap, 2015). The internal information system supports demand forecasting for accurate inventory, provides relevant analytics capabilities to varies internal…

    • 1009 Words
    • 5 Pages
    Improved Essays
  • Decent Essays

    In the case of the State of Washington’s EDIE database, information technology and systems support helped in managing the EDIE data. It organized, stored, assessed, analyzed, and interpreted patient data whenever they visited the Emergency room. The data in the EDIE database became information and then knowledge to physicians which supported them in making fast decisions on patients admitted to the emergency room. Thus, having a well-managed database puts an organization at a competitive advantage. The emergency visits dropped as well as substantial amount of the state’s Medicaid costs.…

    • 284 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    The Relational Database Framework The collection of information provides access to the network of the data-processing system. The representation consists vital information of real-time events. The objective requires managing personal cognizant comportment for integrating vital information. The standard utilizer and application (APP) program interface to a relational database is the Structured Query Language (SQL) (Codd, 2003-2016).…

    • 448 Words
    • 2 Pages
    Improved Essays
  • Decent Essays

    The company that I choose was PNC bank. I think that the database that would be most beneficial would be a transactional database. A transactional database is a database management system (DBMS) that has the ability to roll back or undo a database transaction or operation if it is not completed appropriately.…

    • 208 Words
    • 1 Pages
    Decent Essays
  • Decent Essays

    Ac 1.1

    • 503 Words
    • 3 Pages

    AC 1.1 1. Absent Management – for it causing the organization multiples problems and substantial causes. By keeping induvial records its enable the company to monitor induvial performance’s and take the necessary action to resolve. 2. Legal necessity – By law, we need to have records for all employment data, for Examples staffs attendance records, salaries, and benefits to check if it meets the requirement as per the agreement, records employment and personal data for compliances purpose.…

    • 503 Words
    • 3 Pages
    Decent Essays
  • Superior Essays

    Zillow Case Study Essay

    • 1460 Words
    • 6 Pages

    The database contains data and information related to the systems, including the details of the users and the transactions, while the DBMS creates, modifies, and delete data in the database, as well as maintaining access control and data security. Zillow’s business is to provide information on real estate and mortgages. It recognizes that it needs to make its data accessible, scalable, reliable, and secure with high level of performance, and a relational database would provide the business advantages of meeting these needs, through increased flexibility, increased scalability and performance, reduced redundant information, increased information quality, and increased information security (Baltzan,…

    • 1460 Words
    • 6 Pages
    Superior Essays
  • Improved Essays

    ANSWER: Question 1: What interactions and discussion need to take place among the marketing, manufacturing, logistics, and finance departments: Launching a new product requires lots of planning in every sector of the company. In this case of Pete’s peanut snack company, investing in the new product should make sure that they are making a profit from every act of launching the product which means marketing, manufacturing, logistics, finance department costs should not be overcome to the profit. The first step to start producing a new peanut product is to forecast the product. The forecasting team must anticipate the future of product by analyzing the same variety product competitors price and demand in the market.…

    • 974 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Ransomware Essay

    • 1262 Words
    • 6 Pages

    Information systems permeate the fabric of everyday life. Families use them to remain in touch, organize their lives, and store memories. Multibillion dollar businesses use them to store critical data, increase efficiency, and maximize profits. They exist on cell phones, laptops, ATMs, televisions, servers, and more. A vast amount of data is gathered, stored, and processed from millions of devices worldwide to influence commerce and advise governments.…

    • 1262 Words
    • 6 Pages
    Great Essays
  • Improved Essays

    AMD Case Study

    • 978 Words
    • 4 Pages

    AMD has incorporated strategies that integrates IT solutions across all the teams with the help of IT to support efficient and responsive supply chain management. A standard ERP (Enterprise Resource Planning) system, SAP has been adopted. AMD uses hybrid Push-Pull: Batch dynamic production controls. Current supply chain challenges that AMD is facing: • Economic uncertainty due to global presence • Pressures from competition • Sensitive towards cost • Different technical challenges • Strong emerging markets • Environment is now too sensitive…

    • 978 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    The organizational objectives of Meditech Surgicals are: - To be a leader in the endoscopic surgical instrument market. - To deliver cost effective and innovative endoscopy surgical instruments to hospitals on time - To provide the best customer service to domestic and international customers Supply chain management plays an important role in achieving the organizational objectives. It aims to link all the supply chain agents to jointly cooperate within the firm as a way to maximize productivity in the supply chain and deliver the most benefits to all related parties (Finch 2006). It helps organization to stay competitive in the market by outsourcing its non core functions and focusing on the core competencies.…

    • 1231 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    HBR CASE STUDY Excel-Pls supply chain management at Haus Mart 1. How is value added in supply chain management through better planning versus better execution? Ans. Supply chain management as we have learnt in this course is managing the movement of goods and services. It involves the storage and flow raw materials, inventory of work in process as well as finished goods from their point of origin to their point of consumption or use.…

    • 1315 Words
    • 6 Pages
    Improved Essays
  • Improved Essays

    “The integration between business processes helped developed communication and information distribution” (“Enterprise resource planning”, 2016). The ERP system eliminated a lot of repetitive steps in collecting/migrating data into different departments. Since the system improved the correctness and uniformity of the information as well, the integrity of the data became much more reliable. All data is now combined and kept up to date in one location. This software made reporting much easier and gave options to additional customization.…

    • 713 Words
    • 3 Pages
    Improved Essays

Related Topics