logo

Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I

Submit a Database Implementation assessment covering LO1 and worth 25% of the module.

23 Pages4682 Words365 Views
   

Added on  2020-09-03

About This Document

Database implementation TABLE OF CONTENTS PART 21 TASK 11 Top down and Bottom up techniques 1 TASK 23 Entity relationship diagram 3 Conversion of ERD in a set of corresponding relations 5 Relational database design8 TASK 39 Tables using SQL query language for Books4U 9 Table Client 9 Table Books 10 Table Transaction11 Table SalesVolume11 Table ProfitMarginP 12 TASK 413 SQL queries and screenshots 13 TASK 515 Enriching and extending semantic content of the database 15 How can they

Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I

Submit a Database Implementation assessment covering LO1 and worth 25% of the module.

   Added on 2020-09-03

ShareRelated Documents
Database implementation
Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I_1
TABLE OF CONTENTSPART 2............................................................................................................................................1TASK 1............................................................................................................................................1Top down and Bottom up techniques.....................................................................................1TASK 2............................................................................................................................................3Entity relationship diagram....................................................................................................3Conversion of ERD in a set of corresponding relations.........................................................5Relational database design.....................................................................................................8TASK 3............................................................................................................................................9Tables using SQL query language for Books4U....................................................................9Table Client............................................................................................................................9Table Books..........................................................................................................................10Table Transaction ................................................................................................................11Table SalesVolume...............................................................................................................11Table ProfitMarginP.............................................................................................................12TASK 4..........................................................................................................................................13SQL queries and screenshots................................................................................................13TASK 5..........................................................................................................................................15Enriching and extending semantic content of the database..................................................15How can they improve application performance..................................................................15REFERENCES..............................................................................................................................17
Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I_2
PART 2TASK 1Top down and Bottom up techniquesTop down and bottom up are considered as those approaches that are known fordeveloping the database. Although both of these approaches are quite different from each otherbut the forte of both these approaches are same. In the top down approach, it is started from thebasic level and then is expanded very specifically but in the bottom up approach, it can becontinued with the very basic details and then it is being moved up. The top down approach isalso considered as the breaking down of a particular system in various sub parts so that theinternal sub systems can be classified easily (Coronel and Morris, 2016). Both these top downand bottom up approaches are classified as very well known strategies that can en used for anefficient processing of information and data and also, it can be used for making appropriateorders associated with the knowledge. Top down approaches are also classified as the stepwisedesign whereas bottom up approaches are considered as combining all the systems together sothat more complicated and complex systems can be considered as well. The representation ofboth these diagrams are represented as following :Illustration 1: Top down and bottom up approach1
Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I_3
The strengths and weakness of top down and bottom up approaches are discussed as under :ApproachStrengthWeaknessTop downIt acts tactical enoughand also, has a loweramount of impact onthe whole processing ofthe organisation. It results in a deeperandmatureimplementation (Bailisand Stoica, 2014).In top down approach,the deployment costsare considered ashigher enough. It provides a limitedrange of coverage ininitial phases.In initial stage, the usermight have to installcustom adapters.Bottom upPassword managementcan be implemented asper the requirement.Manual processes canbe replaced very easilywith the bottom upapproach.The whole structuremight have to bechanged according tofuture requirements.Instead of businessoperations, it focuseson the infrastructure.So, it can be classified that top down approach is considered as that approach which is tacticalenough but has a limited coverage. So, it can be used in many cases but also, there are somecases in which it is not being used. Also, it has been observed that in case of top down approach,there might be the possibility of delayed amount of returns on the investment. All the functioningof the operations and services have a slighter influence on the organisation that is following thetop down approach. As there are various benefits of the top down approach, there are some2
Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I_4
drawbacks as well. The organisation following a top down approach makes a proper andcomplete involvement of all the services and operations and that is to be managed by differentapplications of the organisation (Hutchison, Kepner and Fuchs, 2015). The initialimplementation using the top down approach is said to be used as a showcase so that it canfurther help in investigating the solutions more efficiently and appropriately. As the top down approach can be classified in benefits and drawbacks, the same way,bottom up approach can also be classified in the same way. Bottom up approach makes thereturn quite early than the top down approaches on investment. Also, the organisation makinginvolvement of the bottom up approach, it has been observed that usually they tend to get thebenefits in the earlier phase only. So, this can be considered as a beneficial factor for theorganisation. But the fact then which is to ensure that is the organisation should stay on a singleapproach only because any sort of fluctuation from one approach to another can make someaffects on the processing speed of the operations and services that are being provided by theorganisation. It thus further helps in maximizing the management skills as well to a huge extent.Along with the management skills, it also helps in broadening the understanding of the person aswell. As there are some advantages, there are some disadvantages as well such as instead ofkeeping its focus on the processing and operations of the business, the bottom up approach refersto the infrastructure of the existing factors and services. There is also the possibility of theimmediate and urgent modifications to the repository ones and the people that are connected withthe same. But a specialised feature that can be implemented by the help of bottom up approach isthat implementation of passwords can be easily set for a maximum number of users so that theprivacy feature can stay maintained. It is important as well because it is obvious that the systemsof the organisation consists of all the details and information about the employees, services etc.So, it should not be revealed to any external body. So, for protecting the data and informationfrom any external or unauthorised person, it helps in implementing the security factors so that thesystems and the data can stay protected of passwords and specific user ID's so that only theinternal authority can have access to the personal information and data. So, it can even assure theorganisation to stay maintained and protected the information and data. 3
Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I_5
TASK 2Entity relationship diagramThe entity relationship diagram above shows that Books4U wants to develop a database that canbe able enough to store more features about the sales per volume and profit margins. Although itis capable of storing the information of the clients, books that have been bought, all thetransaction details, it also wants the new database to store new features such as overall volume ofsales per existing client, sales volume per category of the book, volume of sales per country, allthe profit margins per category of book, profit margins per country as well. The database has toinvolve recording various functions such as all the details of clients, books that have beenbought, all the transaction details that which book has been issue when and to which person etc.Along with this, the database should also be capable enough of recording the sales informationand the details of the profit margins. But one factor that needs to be ensure here is that thedatabase should be accomplished of high security features such as data hiding and access controlso that no external or unauthorised authorities can be able to have access to their personal dataand information. It will help them in maintaining an efficient level of security in the processes4
Table of Contents Part 21 Table Sales Volume 11 Table Books4U 9 Table Client 9 Table Books10 Table Books10 Table Profit MarginP 12 TASK 515 Enriching and Extending Semantic Content of Table Database I_6

End of preview

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

Related Documents
Logical and Physical Database Design and DBMS Functions
|10
|1108
|66

ER Modelling
|42
|8092
|1

(PDF) Database Management: Concepts and Design
|19
|1237
|144

ER Modelling
|9
|1312
|51

Database and Analytics (Database and Analytics) for the Auto Sale's
|33
|5085
|217

Data Modelling and Sql Language - Assignment
|18
|2256
|44