Interview Question in Database Design
Interview Question :: Please help with DOMAIN MODEL diagram
I applied for a job online and the Hiring Manager sent me this. I am an experienced ASP, SQL, and .NET programmer, but I am unfamiliar with these concepts.
--------------------------------------...
http://en.wikipedia.org/wiki/Domain_mode...
Programming Exercise:
We’d like you to build out the domain model for the application described below. We will be looking at the design decisions you make and methodologies, patterns, and OO principals that you employ in your solution. We’ll review this with you during the meeting. A UI is not necessary though the solution should be demonstrable.
Please complete at least four of the eight stories below.
An owner of a bank has recently decided to expose their banking functionality over a web based interface to reach a larger audience. You have been brought in to work on the core object model that will be leveraged from the user interface layer. The bank owner presents you with a list of the following stories that the object model needs to accommodate.
For the purpose of simplicity, an account holder can have at most 1 account.
Forget about the security aspect of the application.
Feel free to make your own assumptions about any of the uncertainty that you may have with the following stories:
1. As a bank manager I can get a list of all the account holders at the bank.
2. As an account holder I can get the current balance of my account.
3. As an account holder I can withdraw money, up to the balance, from my account
4. As an account holder I can request a transfer of money between my account and the account of another account holder, up to the balance of the account being transferred from.
5. As an account holder I can get the current balance of my account in a different currency (let’s stick to US and CAD).
6. As a bank manager I can get the balance for any account as of a certain date.
7. As a bank manager I can get a list of :
• The Top Five Account Holders (Based on Balance) – Sorted by balance descending
• The Bottom Five Account Holders (Based on Balance), sorted by balance ascending
--------------------------------------...
I installed Visio and I did sort of a scooby-doo drawing. There does not seem to be any UML standard, and I have no way of knowing if it follows Visio standards.
http://miayawear.com/image1.gif
http://miayawear.com/image2.gif
I also did a database diagram. That was the easy part. In fact it would have been nice to just do a database diagram without having to do the model. I mean shoot it would have taken me less time to build the entire website than it took me to draw this stupid model.
http://miayawear.com/drawing1.vsd
Loading ...