Relational Database

Improved Essays
Discuss the advantages of a database management approach to the file processing approach? Give examples to illustrate your answer.
According to our text, database management is the process of storing data. In the early days of computers, they would use data resource management to store information in a specific location. This process was very inflexible and extremely costly. Instead, we use database management today. This process allows us to consolidate the data, and integrate it into many different storage locations. It also allows users to edit, upload, download, and read specific files. An example of a database management would be a cloud service. Users can store their files onto cloud, and any user can access them from around the world.
…show more content…
Many microcomputer database management systems use the relational database model. In the relational database model, data is stored into a two-dimensional table. This allows data to be inputted into multiple fields, and can be retrieved simultaneously. If a manager wants to retrieve an employee’s name, birthdate, and salary, all the information will be contained in the relational database model. One major advantage of the relational database model is that data can be linked, which allows the user to save data in different locations. The limitation to a relational database is that it is only two-dimensional. This limits the amount of data that can be inputted and retrieved.
How will wireless information appliances and services affect the business use of the Internet and the Web? Explain.
The use of wireless information appliances and services will be relatively positive. Wireless technology such as mobile devices are currently changing the way we use the internet and web. A business can perform meetings via smartphone apps such as facetime or skype from anywhere and at any time. Also, a business can reach its customers and suppliers from virtually anywhere. They can use social media to stay in contact with their customers.
What are some of the business benefits and management challenges of client/server networks? Network computing? Peer-to-peer
…show more content…
A node is a small cell system, normally a block or two, that uses fiber optic cables, and small antennas. The antennas are strategically placed in a large city on top of light poles, street signs, or any other place that is optimal. Each antenna is connected to a fiber optic cable that allows for high speed internet interaction. While this idea seems a little farfetched, it is actually being implemented today in Houston, Texas. Texas Medical Center has roughly nine nodes installed at their campus. All cell phone usage is routed through these nodes, and there is no use of a conventional cell phone tower. This idea is sparking a new debate with major carriers such as sprint, and Verizon. Both want to continue to invest in this technology, and it may make stakeholders

Related Documents

  • Decent Essays

    Unit 10 D2

    • 502 Words
    • 3 Pages

    Task 10 (D1) Discuss how potential errors in the design and construction of a database can be avoided. One of the potential errors that can occur when creating a database is that field names and names can be spelt incorrectly due to human error this can be difficult to spot if the database is big the way of making sure that there are no naming errors is to make sure that every is checked regularly and more than twice to make sure that the chances of finding a spelling mistake is reduced. Using the wrong data type is another potential error that can occur when creating a database this can be troublesome as if there is a relationship created between the tables and the mistake is found and changed then the database wouldn’t allow you to change the field where the data type is incorrect without removing the relationship first so it will be made into a long process of removing the relationship between the tables changing the data types for each of the table before remaking the relationship between the tables again the way of preventing this is by looking at the field names for the database and then choosing the correct data type also perhaps getting the opinion of another person and rechecking that they are all correct before creating the relationship.…

    • 502 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    Consequently, this is an opportunity of mobile phone companies, which support for this project for example, Verizon, AT&T or T-Mobile, have more channel for advertisements of their own promotion or new innovation. Moreover, another objective of this project is that to provide the Internet to needy people, who cannot afford to pay for high cost of network (LinkNYC benefits outweigh costs, 2014). This implies that Mobile phone companies will have more potentials to provide a service for people who have lower income or find new customers especially in a low income…

    • 1026 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Discussion Questions Why did PepsiCo Russia invest in a new portal with social network capabilities? To learn what users expect of social sites, the project team looked at Facebook, Linkedln, Google+ we studied the user experience of the world’s best social networking sites, and combined it with the concepts of enterprise portals. 2 How can intranets help companies achieve their business objectives?…

    • 1423 Words
    • 6 Pages
    Great Essays
  • Great Essays

    Case Study Assignment – I Campbellsville University MASSIVE DATABASE MASTERING - MASTERCARD INTERNATIONAL Various affiliations are endeavoring to address the open entryways and limit challenges related with "huge data." Industry masters gage that the total volume of data is increasing at general interims and most by a wide margin of new data being delivered is prepared to go spaces. MasterCard Universal (www.mastercard.com) is not any more impossible to miss to think about the issues identified with monstrous databases. MasterCard has amassed a data circulation focus that is more than 100-terabytes in size. Insiders expect that it will create to more than 1.8 petabytes.…

    • 933 Words
    • 4 Pages
    Great Essays
  • Great Essays

    Upon implementation, it will be easy to record the availability of backup tapes and security issues can be reduces as well. 9. Lack of Data Center…

    • 1326 Words
    • 6 Pages
    Great Essays
  • Great Essays

    Role-Base Access Control

    • 1421 Words
    • 6 Pages

    Role base access control (RBAC) can be defined as granting access to computer resources and network resources to individuals based on the roles they play in an enterprise. For example in a hospital setting which comprises of doctor, nurses, pharmacists, this users do play roles in the hospital setting and they are granted privileges based on the role they play in the hospital. Doctors could be granted privileges to write out prescriptions, modify prescriptions. A pharmacists will be granted permission to dispense prescriptions but not to write out prescriptions. The application of this model is apparent in commercial data management systems and it is widely used due to the papers written by Baldwin describing a database system using role…

    • 1421 Words
    • 6 Pages
    Great Essays
  • Improved Essays

    Relational Database Paper

    • 800 Words
    • 4 Pages

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

    • 800 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Minitrex System

    • 1052 Words
    • 4 Pages

    This will help the workers in organizing client records. Also, this helps organization to build their association with the…

    • 1052 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Outsourcing Trends

    • 1566 Words
    • 7 Pages

    Briefly describe the technologies that are leading businesses into the third wave of electronic commerce. The key technologies that are leading businesses into the third wave of electronic commerce include mobile phones and tablets along with high-speed networks that allow users to access the Internet and smart cards and radio frequency identification devices (RFID) that are being used with biometric technologies such as retina scanners and fingerprint readers. In about 100 words, describe the function of the Internet Corporation for Assigned Names and Numbers. Include a discussion of the differences between gTLDs and sTLDs in your answer.…

    • 1566 Words
    • 7 Pages
    Improved Essays
  • Improved Essays

    CRUD – Defining Information Ownership When developing and implementing a relational database, defining the information and users of the system enable definition of the business rules defining the components of the database management system. An example can be evaluated through the use of a CRUD – create, retrieve, update and delete – matrix as it relates to student information and the individuals or departments related to the school that may require access. The resulting model will be used to interpret business rules and explain how they relate to the components of a relationship database model. CRUD – Create, Retrieve, Update and Delete Purdue (2014) suggests the use of the CRUD two-dimensional table to visually summarize data usages by function. In the student/school relationship model, one possible interpretation of this diagram has been modeled in Table 1.…

    • 778 Words
    • 4 Pages
    Improved Essays
  • Superior Essays

    Another situation a database would be regarded is for when a person would like to check their emails in their inbox database to quickly identify any received messages for offers and private messages to send quick reply. The last situation people would use databases for day-to-day use is using the internet to purchase items, database systems are always used by e-commerce businesses for customers to search for an advertised item, find the price and any other information of the product in one place to come to a…

    • 1005 Words
    • 5 Pages
    Superior Essays
  • Improved Essays

    Normalization is the process by which a data is formatted into relationships that can be easily delineated into respective tables to make Database Management Systems capable of utilizing the data effectively. With normalization, information can be confidently accurate in any system and it is to a business’ loss if the fundamentals of normalization are ignored. So what does Normalization look like? There are four levels called first, second, third and fourth normal forms.…

    • 735 Words
    • 3 Pages
    Improved Essays
  • Great Essays

    Introduction In the modern world, the word “smart” is used everywhere from homes, to the schools, hospitals, market and businesses-to mention but just a few. Generally, people have come to love the word smart and want to be smart or even have smart items with them. Parents would want their children to be smart; people want to buy smart products like the Smartphone. The reality is that, you cannot avoid smart products in the modern world.…

    • 977 Words
    • 4 Pages
    Great Essays
  • Great Essays

    PROFILE OF ORACLE CORPORATION Oracle Corporation is the world's leading supplier of software for information management and the largest database software company which is headquartered in Redwood City, California, United States. The company offers its database, tools and application productsin more than 145 countries around the world and the second global revenue after Microsoft in year 2013. The product such as Middleware,Oracle Beehive, and Oracle Database bring a large changing in the lifestyle of human and system operation of job. It employs 21,000 based in the US while 22,0001outside the US. Identifying relational databases, as a great business opportunity is one of several brilliant moves Ellison made over his career.…

    • 1897 Words
    • 8 Pages
    Great Essays
  • Superior Essays

    1.0 QUESTION 1 Differentiate between database management system and information retrieval system by focusing on their functionalities. DATABASE MANAGEMENT SYSTEM INFORMATION RETRIEVAL SYSTEM DEFINITION A software system that enables the computer to do the database functions such as storing, retrieving, adding, deleting, and modifying data A built-in user interface that carry the activity of obtaining information resource from a collection of information stored EXAMPLE Microsoft Access, MySQL, Oracle, and Microsoft SQL Server Web search engine ADVANTAGES -Controlling data redundancy -Data consistency -Data sharing -Data integration -Integrity constraints -Data atomicity -Database access language -Development of application -Creating forms -Report…

    • 1607 Words
    • 7 Pages
    Superior Essays