Database Design & Development Assignment
25 Pages6575 Words323 Views
Added on 2020-10-22
Database Design & Development Assignment
Added on 2020-10-22
ShareRelated Documents
Database Design &Development
TABLE OF CONTENTSINTRODUCTION...........................................................................................................................1PART 1............................................................................................................................................1Producing user and system requirements...............................................................................1Fully functional system for Tesco..........................................................................................2Clear statements of system and user requirements.................................................................4Effectiveness of design in relation to user and system requirements.....................................5PART 2............................................................................................................................................8Evaluating the effectiveness of database system in relation with user and system requirements:base tables:..............................................................................................................................9Improvement suggestions for the developed database of Tesco: ........................................11PART 3..........................................................................................................................................12TASK 4 .........................................................................................................................................16Technical and user documentation for Tesco ......................................................................16CONCLUSION .............................................................................................................................22REFERENCES:.............................................................................................................................23
INTRODUCTIONDesigning of database is considered as involvement of all the factors that are necessary toachieve all the objectives. After a successful designing of the database, implementation phasetakes place when the designed database is being analysed on actual and real applications. It alsohelps in analysing and checking the reliability of the database (Harrington, 2016). The report isabout analysing the system as well as user requirements of Tesco. Also, the report will involve afully functional database system for Tesco that can help the firm to replace all the manualprocessing of operations and functions. Also, it includes testing of the database system. Atechnical and user documentation of the database designed and implemented for Tesco has alsobeen included in the report.PART 1Producing user and system requirementsA variety of operations and processes in Tesco are being done manually, because ofwhich the management has to face some issues while analysing their market position andcompetitive advantage. It is because in case of manual processing, there are chances of datagetting lost. So, Tesco has decided to make involvement of a proper and developed database sothat they may not have to face any issue regarding analysing their market position. As they areimplementing a database, sot here must be some user as well as system requirements so that thefirm can be easily able to cope with the different challenges of the market place. Userrequirements here can be considered as the fact that Tesco needs a database that should befriendly and reliable enough so that employees can easily able to access and use the database. Itshould be user friendly and less complicated so that the employees and management of Tescomay not have to face any further issue with the database. System requirements can be classifiedas the fact that the systems in which the database has to be implemented should have allsoftware's up to date so that the database cannot throw any extra load on the system (Elmasriand Navathe, 2016). Also, along with the software, hardware installed also should be up to dateand have an efficient amount of RAM so that while operating different processes and operations,Tesco may not have to face any issue or complexity such as hanging of system etc. 1
Fully functional system for TescoThe relational database system for Tesco is designed in a way that it not only facilitatesthe easy data handling for Tesco but also makes it easy for the customers to interact withorganisation via easy user interface. The designed database system consist of different sectionssuch as customers, sales related data, product description and suppliers details. For sustaining theeffectiveness of the database system the system is provided with features such as datanormalisation and data validation. It is one of the most common practices that unknowingly userscan put invalid data in certain fields of the database tables. For instance in the contact numberattribute user can feed invalid number or alphabets. This can create error in output or even canmislead the administrator leading huge losses. To avoid such instances data validation is used. Data validation is a defined set of rules ensures the validity of the data stored in the databasessystem. They enhance the consistency and functionality of the system (Coronel and Morris,2016). 2
Data validation techniques: For validating data designers defines the input data requirements so that any error due toinvalid data can be avoided. Data validation can be achieved by various techniques. The most common technique is the restricted data type. Designers can fix the data typewhich must be followed during data processing. For instance if a rule is fixed during tabledesign that name attribute must be sequence of characters it cannot be numerical valuesthen user will not be able to mislead system by feeding inappropriate values to thecolumn. In the designed database system along with data type restriction property of requirementis also used. Due to this property if users of Tesco will try to leave any attribute emptythen database system will generate an error message. This technique is useful in avoidingnull values. For security reasons if it is essential for organisation to fill the name andcontact details properly then users will not be able to enter null values in the columns. Along with data validation designed database system is also able to decompose tables. Thisapproach eliminates the redundancy. Thus, with normalisation techniques only useful andsensible data is stored. It will be helpful for Tesco as it will make system fast as well as moreefficient. Without normalisation database will consume additional memory and system willbecome slow as well as full of repeated useless entries (Bhogal and Choksi, 2015). Designedtables follows following normalisation rules. First normalised form (1NF): According to this rule table attribute cannot hold multiple values.For example for a single employee code user cannot feed two different names. It can feed onlyone name for one id. Second normalised form (2NF): The developed system is in 1NF form and it does not have anykind of partial dependency thus it is also said to have 2NF. Third normalised form (3NF): The designed tables are 2NF are does not follow transitivedependency thus they follow the third normalisation rule. 3
Clear statements of system and user requirementsUser and system requirements of Tesco for an efficient designing and implementation ofdatabase are discussed as under :User requirementsUser requirements at the time of designing and implementation of database are asfollowing :The database should be reliable enough so that it can be quite easy for Tesco tounderstand its processing. The database should not throw any load to the system. The database should be compatible with various operating systems, which means thatthere should be no sort of restriction on using the database on any specific operatingsystem (Mukherjee and et.al., 2016). The database designed should be suitable enough tobe run on any operating system. It means it should be compatible and reliable enough.4
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Design & Development- Doclg...
|31
|5788
|349
Database Design & Development - Doclg...
|17
|3973
|479
Database design and development Assignment Samplelg...
|20
|5246
|146
Principles of Software System - Ethics, NFR, Requirements Collection, Software Reuse, Test Case Scenariolg...
|9
|1822
|448
Employee Management System - A Solution for Efficient Employee Managementlg...
|7
|1056
|499
Functional and Non-Functional Requirements of Warehouse Management Systemlg...
|9
|905
|3