Database Design Interview Questions 

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

Hello everyone!

I have a bit of a problem with Visual Basic here. I'm basically working with a database that displays bikes for a company which has a number of different bike dealers. I need to design the site like this - the dealer signs in on the front page with their unique password given to them (I have the passwords in a database) and the GridView (or maybe something else would be better?) should display only that particular dealer's bikes. Now, this is the tricky part because I have no idea how to achieve that, neither by means of an SQL query nor VB codebehind. Answers would be very much obliged.

NS

my site is linked to a mysql database. For simplification, my main objective is to track journal entries and what date they were recorded on.

Desired Output:
Display a calendar in a table that has corresponding a hrefs if that particular date has an entry. Left Arrow and Right arrow at the bottom so the user can scroll through the months.

Database Setup:
1st Field(Store Dates) - INT(field type) - ex. 060830201255 - yymmdd-hhmmss - set as primary key
----August 30, 2006 8:12:55 PM
2nd Field(Store Journal Entries) -Text(field type) - ex - This is my entry for today, hello world.

a) Do you suggest that i add a field (listID) INT(field type) and make it auto increment....... and make this the primary key instead?
b)For storing the dates, should i make it a string(as above) or just use php datestamp or timestamp.

All this boils down to SQL FETCH staements and whats easier/faster to pickup the date within a specific range.

Also, any ideas on the calendar design.

TY

1> Some web pages can never be saved by File-->Save Page As menu. There are some whose source even can not be saved. How to design such pages?

2> How to prevent images on a webpage from being copied or saved?

3> Please describe a few real life methods to add counters on a web page. Must be in java or jsp.

4>In jsp I retrive a database row in a variable say 'x' using jstl <sql:query ....> tag. How to access the variable in <jsp: forward......>
tag or some other <jsp:.....> tag or in <%...........%> tag or in <%=.....%>
tag.
This is the 3rd question I'm asking in yahoo answers. My previous 2 questions gathered only one useless answer each. Is yahoo a place only for questions like "I need a G/F........" etc. I'm inclined to believe so. Please note that I will choose best answer, if any answer is really useful.

I heard that microsoft access isnt good for big databases is this true and whys tbhis the case ? As we have a group and we're designing a database we need to keep 1000 records and what would the the best software be? for this becuase we know how to use access we know the basics of how to use oracle is it worth learning about these programs what can u do in the various prograMS that u cna't do in the other any help would be so much appreciated!
thanks for you time

I am creating a database for vendors and their services. I have three tables, VendorID with vendor info and an ID number as a primary key. I have ServiceID with the services I am using an ID number for each of the services. Then I have an intersection table linking each vendor ID with the service ID's of the services they offer (some offer more then one service), so it is a one to many relationship where I have the vendorID from vendorID table linked to the vendorID of the intersection table and serviceID on the intersection table to the serviceID on the serviceID table. I need one or more forms that will let me add vendors and possibly add new services too. I do not know SQL, I prefer wizard mode, but I can use design mode if needed. Any help?

Hello, I am not a complete novice, but I recently have been offered to design/build a website from nothing, and I need step by step instructions.

I need to build a small database driven product catalog using .net pages and either MS Access or another dbase (Im not sure what I need)

What are the steps to set up the server first?
My client is going to give me remote access to their server, but I don't know what is needed on it or what to install first?
Do I need to pay for anything to install on the server, or can I just upload the code/assets and mdb file.
It cant be that easy?

Basically, I need a 10-12 page site, I can design the pages but I need help with the following:

1) a product catalog search function, ( master prod list, specific prod, product detail page)
2) login screen for downloading specific .pdf files or whatever
3) small content management system for client to update pages on their own after Im done.
4) code site for search engines (SEO)

My client is not technical at all, and I have a web designer background, so I could use some handholding.
Also, is their a way to copy a product catalog database and modify it to fit my project,
I have some knowledge of programming and databases, but I cannot right the sql tables or programming logic myself
(although I would like to learn) I am familiar with markup languages and the front end but I need to connect it to a backend and make it work.

Any assistance from professional developers would be great
Thanks

What is the best and easiest to use shopping cart software? I already have an existing website and design so it would need to be customizable (I hate templates). I can program (hand code) in html and javascript but do not have database programming skills so anything requiring extensive knowledge of SQL, ASP.NET, etc., is out of the question. I want something easy to use (or easy to learn), something that can possibly be incorporated into Dreamweaver, and something that is fairly inexpensive. Any suggestions?

It involves the conversion of an access database to MS SQL Server, and adding a lightweight web interface, you will receive specs and be expected to follow a specific software development methodology, it will be divided into phases, testing will first be done by you then me.

The kind of person I am looking for:
- a .NET, must have sound knowledge of ASP.Net
- knowledgeable and experienced with SQL Server.
-prefereably 3 years experience in the above.
-data conversion\migration (Access to SQL server)
-DB skills (normalization etc.)
-knowledge of the various software development methodogies
-good understanding of foundations such as data structures, algorithms, design patterns.
- A portfolio of projects you have worked on.

The alternative is a Java Programmer with J2EE, Jsp knowledge.


The database has to be Microsoft SQL server.

If you are suitable we can organise a video interview and your terms.

you can email me at bijosn@gmail.com

I have more projects, so if I am impressed with you I would like to continue working with you.

I am re-designed a database we use - hopefully to make it easier to update in the future.

At the moment i have 2 tables - one for a list of occupations (80 of them) and a table for client details which gives 6 choices to choose a job.. There are 80 queries for each job that picks out what client is interested in that occupation.

What i'd like to do is have a form, that has a list box or a combo box. The user clicks on a job from that and next to it, the query displays for that particular job. I want the user to be able to click on another job right away and then that job displays.

Is this possible?

any help would be great.

i'd rather not use macro, vba or sql.


thanks.

I was always looking to create a registration page and a login page so whichever users visiting my website can create an account so that I can have some details about the user who is suring on my website.

So, I wanted something like this >>

1. To create a registration form with the following fields :

Username
Password
Email Address
Address
Tel
Occupation
Hobbies

And then their should be 2 buttons at the end of the page -> Submit , Reset

Then when the user clicks on the Submit button, all of these details should be stored in a Database, say for e.g. Microsoft Sql Server


After this, I wanted to create a Login page wherein a user enters his name and password and clicks on the Login button. As soon as he clicks on the Login button, the website should go to the database and match the username and password entered by the user with the data in the database (In other words, validating Username & Password with the database).

If his username and password matches, then he should successfully login into the website.

If his username does not match, then it should display a message, 'No such Username' and if his password does not match, then if should show a message 'Invalid Password' and provide a link to 'Forgot your Password' page.

Next, I want to create a Forgot your Password page wherein the User is asked to enter his username or email address and if it matches, then the password should be sent to his email address which was provided at the time of registration.
and he should be displayed a message that an email containing a password has been sent to his email address (The email address should be displayed where the password is sent)


So that's the above all story that I want to put in action.

Now, what I know is :

I need a database such as Microsoft Sql Server.
I need a web designing software such as Macromedia Dreamweaver MX 2004.
I need a 24hrs internet.
I need a new computer say P4 as a server where the database and my website will reside.

What I don't know is :

From where to start.
What is the method for creating the above work.
What else is required for creating the above work.
The entire code for : Login Page, Registration Form, Forgot your password page.
How to configue the database, connect to the database how to test whether everything is working fine.

So, please can you help me out???

I'm 33, a single female and I am so bored with reading, reading, reading my textbooks. I will graduate with a B.S. In Business with an emphasis in Information Systems in May 2009. (My last class ends March 5th).

I am currently in a database Management/Spacial Analysis class and I am having a hard time understanding the book called Database Concepts (3rd Edition) by David M. Kroenke.

We just went over SQL (for access) in class last week and since I know nothing about SQL-I am getting fusterated just thinking about it. We will be tested on one or two SQL statements. Reading the book is fine if I really understood what I was reading.

My instructor knows that I am having a difficult time with grasping the concepts in this class. I'm more of a doer and I am practicing designing my own database of films in Access 2007. (I am not using SQL to retrive any queries). I find myself spending more time in Access building own personal database of films and less time reading my textbook.

(Mind you, this is the University of Redlands School of Business and each class is 6 weeks long-one night a week). I know that in each class our instructors wants us to get the concepts-if we get the concepts, we can get the meat.

I was told from someone that I should be very careful in my senior year since that is the time that many student flake off and become tired. It seems that the same is happening to me. I love the school that I am in and stopping school is not an option for me. I only have 4 more classes and then I walk/graduate.

Any advice on what I can do to help myself get back into the mood of reading? (We have a break once every 12 weeks. We have one 6 week class, then the next 6 week class, then a one week break. My next break will be in late August. The last class I had was E-Business and Security and the book on Security (for systems and physical) was great! )

I'd love to "get away", however, without a car-it does make me feel like a teenager all over again with no where to go. I just stay home everyday, looking for work from home on my computer...and doing this school work.

Any advice?

Hi! Our companies has two off (1) G'dham which is main off (2) in Baroda

= In G'dham off =
* There are 30 comps connected in LAN
* 6 comps running Win98, 1 comp is Win 2003 server (Standard) which is configured as File Server rest comps are Windows Xp.
* There is no Domain Controller, comps are connected in Workgroup.
* All the users working on customiszed software designed in VB6.
* Database connectivity is provided through SQL Server 2000 which is installed in Windows 2003 server.
* All the nodes need sto be install all the necessary softwares like VB6, Crystal Reports,

SQL server client installation to run the customazied software.

= In Baroda off =
* There are two comps
* one is windows 2003 server and one is Windows Xp.

= The need =
* We want to connect Baroda off comps with G'dham off so that Baroda off comp can use the same connectivity of G'dham off data.
== ?? ==
* Through bsnl broadband? Which business scheme? Unlimited or any other? wht is VPN ? static IP? how to use?

I am a university student and because of the rising cost in here, its really hard to do extra curricular things like purchasing good study material, books, laptops etc. And I am searching for online jobs or consultanting companies who can give me work to do. I am good at programming microcontrollers, motion controllers, GUI using .net, VB, C#.net, C++, and little bit Java. Very good in PLC programming, SCADA design, SQL, databases, and XAML/XML. Prior to my university I have a work experience of 7 years as a systems architect. Other area is business analysis and project design. Unix, Linux and Windows are my strong areas to work.
Need help in terms of projects to work from home.

Thanks,
SM

I have heared that ASP.NET is used for interface desiging but if in .NET forms are provided the why we need to design interface.Similarly if SQL server is used for databases then why we use ADO.NET. Thanks