[讨论]MSFT interview question-第1页

starla

0操作1 ^#

[讨论]MSFT interview question

You want to design a database schema to describe the following situation for a car-sharing business:
· You have a set of users, each of whom has a name and secret passcode used to enter the garage. Each user can have multiple credit card numbers registered in the system; obviously, each credit card can only belong to one person.
· There is also a set of cars; each car can have multiple drivers allowed to drive the car, and each user can also be allowed to drive multiple cars.
· Describe the table layout you would use to represent this business, indicating the nature of the relationships between tables, and the primary and foreign key relationships.

Anybody can provide hints on that.

cheer_up

0操作2 ^#

I think you should have five tables: user, user_car, car, car_user, rental

table user have one to many relationship with table user_car, so you can find how many cars does each user has
table car have one to many relationship with table car_user, so you can find how many users does each car has
table user, rental, car should have one to one relationship among them, so you can find who is having the car now

any comments? good luck

starla

0操作3 ^#

thanks a lot, this is the question I found on the web but can't find answer.

magicflute

0操作4 ^#

what is MSFT?

tfhu

0操作5 ^#

This is an interview question from ebay/Paypal, maybe it was a Microsoft question previously.