Database with Maintenance-Driven Approach

Building Database with MDA

A maintenance-driven approach is better than tools-driven approach; although with the tools-driven approach, it's easy to get the work done once you know how to make use of the tools also tools-driven approach is good for departmental application development. 


In a nutshell, many applications are more scope beyond that of a departmental level where you will anticipate changes often-Enterprise level. Here you will learn how to use a maintenance driven approach to creating a database that could anticipate changes. Using this approach involves the logical separation of concerns, where the presentation, domain, and the persistence layers need to work together to get the work done.

Step1: Create a project-LocalDbMDA
Then rename this project to LocalDbMDA.Presentation, This layer present the end result of the application to the end user.
LocalDbMDA.Presentation
LocalDbMDA.Presentation Diagram
Step2: Adding New Projects to the Main Project
Ideally, It is good to make the Persistence and the Presentation layers depend on the Domain
Now we need to add the 2 other layers the domain and the persistence layers by selecting from the menu for each new project.  File > Add > New Projects. Moreover, right within the new project Dialogue, choose Class Library, and be sure that the selection for the solution is changed to 'Add to Solution' and not 'Create New Solution'.
 Then named the new file LocalDbMDA.Persistence. Repeat this step to create LocalDBMDA.Domain, right after this press Cltr+Shift+B which is the shortcut key to build a solution.

Step3: Set Dependencies through Add References
Ideally, you do not want your project to depend on each other, which is the main principle of SOC. But some level of dependency is going to be needed. A project taking dependency from another one simply means a project makes reference to another one in code. Now the Reference logic that we will use for this lesson looks like this:
                      Reference                 Reference
Presentation -------------->Domain--------------> Persistence

layer, which will keep the dependency chain central to the Domain layer, like this:

                      Reference                      Reference
Presentation ---------------->Domain<--------------Persistence

Re-create the Entity Model in the Persistence Layer and also add Data Transfer Object that each layer will reference. This DTO allows data transfers access within the other 3 layers.


Note:
In order to facilitate the development of a system in a piecemeal fashion and simplify making changes in the system, its decomposition into subsystems must follow the advice of patterns of assigning responsibilities (General Responsibility Assignment Software Patterns, GRASP) like Low Coupling and High Cohesion.

Low Coupling means in this context that a subsystem should not depend too much on other subsystems. It helps us to achieve low dependency of subsystems, low change impact of subsystems, and increased reuse of the artifacts that are created during the development of subsystems.

High Cohesion means in this context that the responsibilities of a subsystem must be strongly related in order to reduce the complexity of subsystems. 

These rules are applicable to creating of a database. 

Database is a set of true propositions (facts) about the real world.
Propositions contain representation of values (data) and their interpretation.
Examples of propositions.
A car manufacturer has a numeric identifier 1 and a textual name "Toyota".

A car manufacturer has a textual name "Mitsubishi", numeric id = 2 and its description is "Rarity".


You can also check out an environment for executing SQL statements based on different SQL DBMSs and a set of SQL puzzles
You can also check these catalogs of data models, that contain logical design models of SQL databases. These help us to understand databases domains and hence are an important source of information for the creation of conceptual data models.



20 comments:

  1. Great articles, first of all Thanks for writing such lovely Post!

    thesimpletruth
    Technology

    ReplyDelete
  2. Great survey, I'm sure you're getting a great response. situs bokep terbaru

    ReplyDelete
  3. it's far my first visit for your blog, and i'm the complete inspired amid the articles which you remedy. deliver satisfying know-how for me. thanks for sharing useful material. I will be urge on the subject of going on uphill for the more massive make recognised. Technical Services Company

    ReplyDelete
  4. I real glad to uncover this web internet site on bing, just what I was searching for. Digitogy

    ReplyDelete
  5. The author trusted that schools ought to likewise give little fiscal impetuses to educators and teachers to go to workshops. prywatnoscwsieci.pl

    ReplyDelete
  6. Mmm.. good to be here in your article or post, whatever, I think I should also work hard for my own website like I see some good and updated working in your site. Finde mehr heraus

    ReplyDelete
  7. At that point the article considers three snags that frequently debilitate organizations from making their ERP dream a reality: kmsauto

    ReplyDelete
  8. I impressed by the quality of information on this website. I am very enjoyed for this blog. Its an informative topic. Very useful info. I am sure I will visit this place again soon. Hope to see more posts soon! Android Applications

    ReplyDelete
  9. Hey, this day is too much good for me, since this time I am reading this enormous informative article here at my home. Thanks a lot for massive hard work. wikitechnomania.wikidot.com

    ReplyDelete
  10. With regards to framework maintenance, precaution maintenance frequently rings a bell.discover more

    ReplyDelete
  11. A progressive technology is one which empowers new businesses or empowers answers for issues that were beforehand impractical.viooz alternatives

    ReplyDelete
  12. The 2005 Energy Policy Act gives two different ways to be given a solar vitality charge credit from the government. Solar vitality discounts are likewise offered by over half of US states. Zonnepanelen

    ReplyDelete
  13. Children can then practice making connections between new and past knowledge, manipulating information in working memory, and problem solving. reggie

    ReplyDelete
  14. You are writing some interesting and best content I also bookmark this URL .You guys are writing some Amazing tips. Thanks for sharing this. Totally Awesome Post Please Keep Posting Regularly.
    echobeat earbuds review, chargeboost reviews, liporing review , doc socks, livewave antenna review

    ReplyDelete
  15. You can begin the procedure by clicking OK.https://www.dbdesigner.net If you don't mind hold up until the procedure is finished.

    ReplyDelete
  16. No other part of a PC fills in as much as the hard drive, and in this way it is crucially significant not to ignore it when cooling issues emerge.
    data discovery

    ReplyDelete
  17. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained!
    토토사이트

    ReplyDelete
  18. It is included in my habit that I often visit blogs in my free time, so after landing on your blog. I have thoroughly impressed with it and decided to take out some precious time to visit it again and again. Thanks. hotmail-login.email

    ReplyDelete

Note: only a member of this blog may post a comment.