database design

robasc · #1 (**permalink**) 03-08-10, 08:33

Hello everyone,

I am working on a computer inventory store database. The store will consist of the following items:

Laptops, Desktops, Servers, PDA's

few of the entities and attributes for a computer store:

Code:

Computers(ser_num, year, make, model, qoh, qty_sold, list_price, cost_price)

I would also need a supplier for the items so I have:

Code:

Suppliers( sup_id, year, make, model, qoh, cost_price)

looking for some other ideas and suggestions for this database?

r937 · #2 (**permalink**) 03-08-10, 08:48

customers, orders, invoices...

robasc · #3 (**permalink**) 03-08-10, 15:40

Here is what I have created so far. I am not worried about the attributes yet I am only interested in the entities and relationships for now:

http://i244.photobucket.com/albums/gg5/robasc/computerstore.jpg?t=1268076962

Internet Services

Web Development

Digital Marketing

Consumer Tech