Issues with Database Management Systems Essay

Added on - 22 Jul 2020

  • 32

    Pages

  • 5860

    Words

  • 121

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 8 of 32 pages
Database Design Concepts1Database Design ConceptsStudent's Name:Instructor's Name:Date:
Database Design Concepts2ContentsTask 1..........................................................................................................................................................31.1-Analyze the key issues and application of databases within organizational environments [1]....3Issues with database management systems........................................................................................3Applications for database management systems....................................................................................4Sharing Information.............................................................................................................................4Eliminating Duplicates.........................................................................................................................5Ensure Security....................................................................................................................................5Backups...............................................................................................................................................51.2-Critically evaluate the features and advantages of database management systems. [1][2]........6Concurrent Use....................................................................................................................................6Structured & Described Data...............................................................................................................6Here is a simple example of how data can be structured into tables:.................................................7Clean Layers.........................................................................................................................................7Data Integrity.......................................................................................................................................7Atomic Transactions............................................................................................................................8Data Persistence..................................................................................................................................8Data Views...........................................................................................................................................8Task 2..........................................................................................................................................................92.1- Analyze a database developmental methodology for the given case study. [3]...............................9Database development involves three important stages....................................................................92.2-Discuss entity-relationship modelling and normalization for the given case study. [1][2][3][4]......13Entity Relationship Diagram..............................................................................................................14Normalization....................................................................................................................................15Task 3........................................................................................................................................................17Design of Tables.....................................................................................................................................17Sample queries to extract data from the system...................................................................................22Form Design...........................................................................................................................................23Evaluation of Design..............................................................................................................................28Support Documentation........................................................................................................................29References.................................................................................................................................................31
Database Design Concepts3Task 11.1-Analyze the key issues and application of databases within organizationalenvironments [1]Issues with database management systemsMany organizations face serious issues with respect to data management. They find it difficultto manage huge volumes of data efficiently. To be more precise, it is quite difficult fororganizations to handle multiple tasks at ease. When it comes to data management, serioushassles are seen with data organization, storage and maintenance. Some companies strugglebecause data serves as the backbone of their operations. They spend loads of money onbusiness operations that take care of mission critical data.Without the right kind of data management systems, organizations and businesses are not ableto generate upright results. They find it hard to synchronize and manipulate data productively.For example, businesses are unable to gather data from various systems like projectmanagement, student information, list of library books, payroll and inventory. These arescenarios with versatile business operations cannot be carried forward.Without proper data management methods, organizations tend to perform tasks manually. Thismeans, tasks require more time and effort to be completed. In fact, data cannot be structuredor categorized to suit the needs of an organization or company.In places where database management is done manually, the following issues are seen:1)It is difficult to maintain the integrity of information2)It is difficult to share data efficiently.
Database Design Concepts43)It is difficult to judge the accuracy and validity of information.4)It is not possible to reuse information effectively.5)It is difficult to maintain data quality.6)It is difficult for upper management to track the overall performance of their business.Indeed, it needs lots of organization and structure to ensure sound businessperformance.In very simple terms, both big and small organizations face issues in connecting five majorcomponents. This includes people, data, procedures, software and hardware. When thesecomponents are not in sync, it can be difficult to focus on better and revenue generatingaspects of a business. That is where database management systems come into the picture.Applications for database management systemsThere are plenty of applications for database management systems in an organization. First ofall, organizations can use database management systems to store huge volumes of information.It is essential for companies to focus on data. Customers can be attracted only with the rightkind of information. Data is valuable for organizations of all sizes. It has to be handled preciselyand with lots of care. Information present in a company’s database should be flawless.Sharing InformationDatabase management systems prove to be useful when you wish to share information. Basedon user privileges, you can share information. Even if your business is located in differentcountries, you don’t have to worry about data sharing. Multiple users can access datasimulataneously from different business spots. This is a unique feature that sets relational
Database Design Concepts5database management systems apart! You will have quick access to all necessary information.With right data at the right time, you can offer better customer service. This is a way offacilitating better work.Eliminating DuplicatesThe talk about database management systems will remain incomplete without the eliminationof duplications. Database management systems should be used in places where dataduplication has to be eliminated. DBMS centralizes information. Centralization removes theneed for duplicate information. This is a common problem faced by many business owners. As acompany adopts to DBMS systems, they don’t have to be concerned about duplicates.Ensure SecurityAnother important application for database management system is to ensure security. Anorganization is bound to have different levels. Employees at each level will have uniqueprivileges and requirements. Database management systems can be used to handle theserequirements and privileges. You can decide and assign access to users based on their role. Thiswill improve confidentiality and security of data. In fact, it is very easy to maintain employeedata too. That is because everything can be digitalized, protected and accessed from anywhere.BackupsDatabase management systems can be backed up easily. This is another critical reason to useDBMS. Organizations have the freedom to store data with “availability” in mind. That way, theorganization will never lack or lose information. Even when hardware devices fail, they will havea way of regaining important data.
Database Design Concepts6On the whole, database management systems are necessary to support all internal operationsof an organization. When data has to be used and shared safely, database managementsystems prove to be handy. An efficient database can handle specialized information easily. It isrequired to ensure and improve business operations.1.2-Critically evaluate the features and advantages of database management systems. [1][2]Database management systems offer a unique set of advantages. These benefits helporganizations like Shoengalleric with easy data management and smooth business operation.Concurrent UseConcurrent use is an important benefit in using database systems. For organizations likeShoengalleric, concurrent use improves the economy of the entire system. Database storageand capture will not be redundant. This means, the system can be operated from a centrallocation. All control will be handled centrally. This is when data manipulation becomes efficient.A very good example of concurrent data use would be:Imagine a travel database of a huge transport agency. Employees are bound to belocated in different branches. They will access the database concurrently for gathering andbooking journeys. Each travel agent should be able to access and work on the database withoutany hassles. When they make a booking, cancelation or an update, everyone else should be ableto see the changes.
Database Design Concepts7Structured & Described DataStructured and described data is the fundamental benefit of database management systems.Every data column in your database will have a complete description and definition.Additionally, you can control the way data is related to one another. Data in DBMS systems aredivided systematically and are linked carefully. There is a way to store and access data from theDBMS.Here is a simple example of how data can be structured into tables:Id [number]Name [string]DOB [date]City [string]1Tom12/12/2012New Town2Jane01/01/2013Grande RoadClean LayersEfficient database management systems separate applications and data. The applicationdoesn’t have to worry about physical data storage. It doesn’t have to be concerned about dataformat, storage, encoding or anything that is related to the physical part of a system. Mostcompanies like Shoengalleric can rely on communication languages like SQL to interact andprocess data. Because data and applications are neatly separated, internal reorganization andimprovements become easy. The changes will have no influence on the application software.Data IntegrityDBMS became famous for data integrity. This is a byword for qualities like reliability and quality.In the broader sense, integrity ensures the protection of data from unauthorized usage. Any
Database Design Concepts8unauthorized changes will not be allowed too! Data in systems is a reflection of real world facts.Logically, data has to be accurate to a good extend. Database management systems tend tosupport tasks and bring only consistent data. All transactions can be controlled to maintainconsistency.Atomic TransactionsDatabase operations are known as transactions. By definition, transaction is a collection ofactions that can be carried out in a database to ensure consistency. One transaction translatesdata from one particular state to another consistent state. All transactions in a database shouldbe atomic. That means, you will not be able to break transactions into smaller groups. Likewise,transactions should not result in an inconsistent database. Here is an example to demonstratethis feature and its benefits.Image a bank transfer, where money goes from one account to another. Money has tobe debited from one account and credited into another account. This is an example of aconsistent transaction. The transaction is atomic too. If money was only debited or creditedfrom a single end, the transaction will result in an inconsistent state. Database managementsystems perform transactions in a similar fashion.Data PersistenceDatabase management systems ensure data persistence too. This is a feature that makes suredata is not destroyed unless the user has programmed or manually wants to. The overalllifetime of data in a database management system depends on the user. It doesn’t depend onthe system. All changes that are carried out in the database should be persistent too. When a
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document