1. Develop a data model for a business application.
2. Design and build a database to store and retrieve data for a business application.
The assignment focuses on the technical design and provision of a new database server and the development of a new database for a Financial Services company accompanied with a Technical Design document.
BankCorp Ltd. offer Wealth Management and Investment Services to its Personal and Corporate clients. Currently, data is stored in a number of systems across the company. This leads to “double keying” and as a result inefficiencies and errors.
They want to create a single database to consolidate all these details into one single source. They do not have any IT staff and they do not have the space or ability to look after any infrastructure on premise. They want you to design and develop the database only. Any data migration tasks will be taken care off in a future different project. The data model must be designed to meet 3NF (Third Normal Form) requirements.
In terms of the key entities they have given you the following list:
A customer can have many accounts and an account can be secured by many securities. A customer can be associated to another customer in the bank e.g. a Property Development company may be associated with a Surveying company.
Associations can be two-way. For example-
Company A is the Surveyor of Company B
Company B has Surveyor Company A
A customer cannot be associated to another customer more than once under the same Association Type.
In terms of data updates they have the following requirement:
• They want the ability to create a new Customer and Association (from the newly created customer to another customer) via a parameterised Stored Procedure.
• They want the ability to delete a customer and foreign key records associated with this Customer via a parameterised Stored Procedure
In terms of reference data they have the following requirement:
Accounts, Securities and Associations can be of several types. They do not want many tables to store each of these types. They want you to come up with a generic way to store all reference data in the database. In addition to this reference data may be removed from the database from time to time – they want any reference to data which has to be removed is done as a “soft delete” as opposed to a “hard delete”.
This way it will remain in the database but will not be visible to the user.
In terms of Management Information they see real value in having a single view on all their clients and the touch points between them and as such want the following extract:
They want an MI extract created as a SQL View which will return the association details between all clients (both sides of the relationship!!!).
Deleted Reference Data View
The company also want visibility of what Reference Data has been deleted. They want to be able to query a SQL View which shows all reference data which has been deleted.
They have come to you as an IT Consultant and they want these requirements developed into an enterprise solution. Along with the final solution you must supply the customer a Technical Design Document with the technical design details of the solution.
The accompanying Technical Document should cover (but not limited to):
1. Scope of the document.
2. Technical Design to include:
a. ER Diagram
b. Physical Model in Third Normal Form (3NF)
c. Technology used
d. Embedded SQL File containing all DDL and DML statements.
4. Reflection on Learnings.
Ruler Solomon Ruler Solomon was the third and the best lord of Israel. He "was the second child of David by his significant other Bathsheba, and the recognized most loved of his dad" (Oussani). Solomon is generally known for his extraordinary insight and just soul. His primary accomplishmen, the development of the sanctuary of the LORD in Jerusalem, likewise made him surely understood and decent among his kin and among different countries also. Aside from extraordinary shrewdness, God additionally gave Solomon recognizing heart, riches, and respect, yet at the same time, toward the end, this didn't keep him from wrongly following different divine beings. God assumed the significant job in the lord's life. Since the day Solomon was conceived, the LORD guided him through his exemplary life; he made him an effective, savvy and observing ruler, administered the country, and manufacture the sanctuary and the castle in Jerusalem. The way that Solomon requested that God give him insight to oversee his kin, not long and upbeat life, extraordinary influence and riches, influences us to respect the ruler and respect his motivation to put the success of his kin before his very own necessities. Some time before Solomon grew up and turned into an amazing lord of Israel, we, the perusers of the Bible, could predict his up and coming achievement. God dependably was with him since the day he was conceived, "and in light of the fact that the LORD cherished him, he sent word through Nathan the prophet to name him Jedidiah" (2 Samuel 12:25). The name Jedidiah signifies "adored by the LORD". "Solomon's insight was more noteworthy than the shrewdness of the considerable number of men of the Earth" (1 Kings 4:30). He utilized his astude and insightful personality to administer over his country and to teach individuals. He gave them valuable information about plants, creatures, feathered creatures, reptiles and fish. The ruler wound up celebrated and noteworthy, among his kin, as well as among different countries. "Man of all countries came to tune in to Solomon's insight, sent by every one of the rulers of the world, who had heared of his knowledge" (1 Kings 4:34). Aside from having an incredible shrewdness, Solomon was likewise an equitable and recognizing judge. The scene in which two ladies request that he choose who is the genuine mother of the tyke is the most acclaimed precedent in which the ruler utilizes his observing heart to jugde individuals. Solomon didn't require any confirmations or the observers to make the privilege judgemen. Not long after subsequent to climbing his dad's honored position, Solomon "bagan to manufacture the Holy Temple" (Schoenber). He was controling the entire procedure of building it. The sanctuary and its development were imperative for the lord. By this, he demonstrated his appreciation towards God and furthermore fulfiled the aim of his dad David. It took Solomon seven years to construct the sanctuary. At last he additionally raised the ark of the LORD's pledge in it. Amid his life, Solomon "created 3,000 adages" (Shoenberg), which are for the most part identified with individuals' regular daily existence. Through hundreds of years, his axioms helped individuals disclosing to them how to carry on with a honorable and fruitful life and showing them how to be just before God: "Don't begrudge a rough man or pick any of his courses, for the LORD disdains an unreasonable man yet brings the upstanding into his certainty" (Proverbs 3:31-32) Nowadays, we can in any case remove some valuable information from these sayings and utilize it to improve our lifes. One of the precepts that we can discover in the book of Proverbs tells: "The dread of the LORD is the start of learning, yet tricks loathe insight and order" (Proverbs 1:7). In the wake of getting comfortable with this saying and realizing that Solomon was insightful, and that the LORD is an envious God, the accompanying inquiry emerges: "For what reason did Solomon pursue different divine beings?" Only after God had rebuffed him, Solomon comprehended that he did insidious according to the LORD. At that point, after Solomon's admissions, which were not totally genuine, God demonstrated his benevolence on the ruler, yet after his passing, the LORD separated the kingdom into two, and the child of Solomon got its littlest piece. As per the Bible, Solomon was the best lord in the Old Testament, who "managed over the general population of Israel around three thousand years prior" (Maris). On account of his insightful and observing heart, that he got from the LORD, the ruler had no equivalents. Being a fruitful ruler and a simply judge, Solomon shown individuals, had assembled the sanctuary for the Name of the LORD his God in Jerusalem, and had stated "3,000 adages" (Schoenberg). Regardless of his incredible shrewdness that was given to him by God, Solomon did abhorrent according to the LORD and pursued the divine forces of his wifes. In any case, he is recognized as an incredible and savvy ruler. Wouldn't it be better if our governers would pursue his case of being simply and perceiving towards the general population? References Maris, Micki. "About the Proverbs of Solomon." Proverbs of Solomon Family Discussion Guide. 11 Dec. 2009 Oussani, Gabriel. "Solomon." The Catholic Encyclopedia. Vol. 14. New York: Robert Appleton Company, 1912. 11 Dec. 2009 . Schoenberg, Shira. "Solomon." Jewish Virtual Library. 11 Dec. 2009 < ://www.jewishvirtuallibrary.org/jsource/history/Solomon.html>>GET ANSWER