Ask a question from expert

Ask now

Database Design Concepts Assignment

28 Pages6083 Words396 Views
   

Added on  2020-06-05

Database Design Concepts Assignment

   Added on 2020-06-05

BookmarkShareRelated Documents
Database Design Concepts
Database Design Concepts Assignment_1
Table of ContentsINTRODUCTION ..........................................................................................................................1TASK 1............................................................................................................................................11.1 Key issues and application of databases in organizations................................................11.2 Feature and advantage of database management system ................................................2TASK 2............................................................................................................................................32.1 Data base development methodology .............................................................................32.2 Entity relation ship modeling and normalization techniques of database ......................5M 1...................................................................................................................................................7D 1....................................................................................................................................................8TASK 3............................................................................................................................................93.1 Database development life cycle .....................................................................................93.2 Functional database design ...........................................................................................103.3 Effectiveness of database solution ................................................................................143.4 Technical documentation of database ..........................................................................14CONCLUSION..............................................................................................................................15REFERENCES .............................................................................................................................17
Database Design Concepts Assignment_2
INTRODUCTION Database management system is an application used to connect with user. It is also usedto interact with various other applications in data evaluation.. Database is an important andintrinsic part for any organisation system. It is tool use by companies to store their data ofemployees. information of their work and various other kind of data. Database are use to storeand extract data. DBMS is an application which is provides organisations a platform on which allthe information is managed. It allows user to access data, update data and searching of data. Itgives many links to user like programming, analysis of systems, human computer interaction andinterfacing with systems. Present report describes about various issues and problems in database application incontext with organisations environment. Evaluation of feature and database of DBMS system incompanies has been done. Further more, development methodology of database in enterpriseshave been evaluated. Entity relation ship model for the given organisation has been illustrated.More over, database development cycle and, concept of normalisation has been explained.Effectivenesses of DBMS and improvements required are also illustrated. Database for torganisation has been designed. Effectiveness an further improvements has been suggested. TASK 11.1 Key issues and application of databases in organisationsThere are various issues discovered in database ofShoengalleric Art Gallery. Databasehave many issue which can effect the proper functioning of the organisation (Abadi and et.al.,2013). Issue like redundancy of data, interdependency, security issue, data integrity and datavalidity. Following are some issues of company's database : Data Redundancy: It is the most vital issue which is found in database of theorganisation. Data redundancy is the condition in which same data is reflected in twodifferent places (Coronel and Morris, 2016). This means two distinct places are showingsame information which is causes repetition problem. Redundancy occurs when two ormore tables in the database holds same value. For example in art gallery shopredundancy can occur when two customers have same name. Security Issue : Security of data is termed data stored in database should be kept safefrom unauthorised people. as Security issue occurs when organisations stores theinformation of customers, financial data, HR records etc. Large amount of information1
Database Design Concepts Assignment_3
contained in database can be steal by hacker for illegal use. The theft of information cancauses loss of reputation of firm. Is also causes problems to customers. Data integrity : It is defined as consistency and accuracy of data. It is indicated byalternation of data within two tables of database. In designing phase of database it isneeded that data is stored ion right table and no repetition/ missing of data is there.Data validity : It is defined as validation of data in the single database. It is a processused to ensure that all the field within the database are showing some valid value.Consistent value is required in the table and table should not return null value (Di andKerns, 2015). For example in customer database of shop amount field of table can notcontain null value.Database system are replacement of traditional systemsIn traditional system data was used to be stores and arranged in file of computers.Processing of data was done using traditional system for file processing. These system causes theproblem of data redundancy and data inconsistency. Integration of data was also a issue. Whereas in the database system these issue of data redundancy and inconsistency are solved. Databasesystem provides user friendly interface and improved data integrity. It also provide security ofdata. Form this it is clear that database system are replacement of traditional systems.Application database in organisationsDatabases in organisation plays an important role in storing data of company. Anorganisation contains three level of functional activities. The data of all these activities within theorganisation is stored in the database. Corporate database holds data related to company,operations and various plans. It provides effective storage of data. It allows users to put queriesand access of data. It provides a platform in which is user friendly and provides easy interactionto users. There are various roles of database administrator which are taking back ups, recovery ofdata, creation of new database, ensuring security of database and upgrading database. 1.2 Feature and advantage of database management system There are various features of database management system that can help ShoengallericArt Gallery shop in managing the data. DBMS applications are used widely by all businessentities to mange the data effectively. Some benefits of database management system in theorganisation are as follows: 2
Database Design Concepts Assignment_4
Data availability : it is one of most useful feature of DBMS which helps in reflectingsame data of firm available to many employees at the same time. It supports in enablingmultiple access to authorized users (Dimitrieski and et.al., 2015). That data is madeavailable to all the users remotely. For example gallery shop can made its data availableevery time to all its branches. Its employees can access data at any time using internet.Minimized redundancy : Data and information stored in which is stored in databasemanagement system is compact and it appears only at one place. This feature help inreducing redundancy of data. For any business for it required that data should repeatagain and again. DBMS help in reducing the cost of maintaining significant informationof business in storage devices.Accuracy and consistency of data : DBMS provides accuracy of data by using dataintegrity feature (Embley and Thalheim, 2014.). It gives user a relevant piece of data foruse. Using database organisations can assist the integrity of their significant records ofbusiness. It provides a platform on which changes are to be made only at one place. Italso prevent faults,bugs, and loss of data. Features of DBMS: Consistency : Implementation of database any organisation benefits them to sue fileformats that are consistent and standard. This feature make the data manipulation andupdate easy. It became easy for business venture to easily update data because there aresome rules in database which are applied to al type of data (Coronel and Morris, 2016).Customization of business records become easier due to this feature.Data structuring : Whole data in the database is stored in the form of hierarchicalstructures. Table, rows field and tuple are used to feed data. It become easier foradministrator to update and recover the data. Query languages : DBMS uses query languages to store and retrieve data. Querylanguage are use for data collection, searching , data sorting, modification andmanipulation . Customized database : DBMS provide various options that can be used to makecustomized elements according to requirement of user. Metadata : Data base management system provides a library which is called metadata.This data dictionary gives information about how data is organized within the system. 3
Database Design Concepts Assignment_5
ACID properties: These properties of database systems supports in safe sharing of data. ACID stands foratomicity, consistency, isolation and durability. Atomicity: It helps in ensuring that all the operations in transaction are reflecting in database.Transaction which is atomic are either complete or not even started. Consistency: This property helps in ensuring that al the data in the database is valid in the end oftransaction. In case of any error in the system change are rolled back . Isolation: It ensure that one action in the system should be carried out only once. Durability: This property ensures that transactions are durable upon successful completion.Data concurrency: Meaning of data con currency is that several users can access data at onetime. It is the ability of database to permit users to perform multiple transactions. Data portability: It is the ability of database to move, copy and transfer data from one databaseto another. It explains the extent to which a data can be ported. TASK 22.1 Data base development methodology According to case study Shoengalleric is an art gallery which is situated in China.Company has many branches sin the country due to which it is difficult for the gallery to mangeits data using paperwork methodology (Embley and Thalheim, 2014). Sharing of information ispoor due to use of old method in storing data. The organisation wants to build its database foreffective management of data. Data base will help gallery in reducing errors in storing of data.Following are the designing methodology that should be used in making of database for the artgallery. The methodology is divided into three parts : Conceptual database design In this designing method conceptual data model is made for the organisation. This modelis totally depends on implementing details like target DBMS,system programs, languages forprogramming and issue of performance (Harrington, 2016). Logical database design In this database design construction information does not depends on particular databasemanagement system. This type of designing method uses conceptual model to make logicalmodel. This model gets affected by data models like relational database model. This logicalmodel works as a source of data for physical model (Hernandez, 2013). It generates output in4
Database Design Concepts Assignment_6

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management Systems Assignment Sample
|40
|7689
|59

Data Modelling and SQL Language
|16
|2546
|97

Information Management System: Assignment
|12
|3467
|412

Database Design and Implementation
|15
|3038
|164

Database Design and Implementation
|15
|3038
|167

Data Modelling and SQL Language : Report
|31
|4640
|88