Thursday, September 15, 2016

Skin Healing

When skin is injured or lost, regrown skin has different appearance than original skin. I think it is possible to re-grow skin same as before injury because once I have seen a case where a small circular portion of skin was lost and I observed skin grown from one portion of circumference of the hole about to fill the hole (it looked like a lid) but could not join with remaining circumference due to dead skin cells in those areas. This grown skin looked same as original skin before loosing. Due to dead skin cells at the boundary, it was lost and skin with different look grew and sealed the hole.

I think the solution is to use a special material which does not react with any part of body, is very plastic and also like rubber to cover the flesh temporarily to protect the wound and remove the dead skin cells from all the boundaries. The wound must be properly cleaned and also surrounding area of the wound and then bandage will be required to keep in place the protective material and protect the wound from further damage. Then the skin cells may regrow same as the original to cover the injury.

Tuesday, April 12, 2016

A thought about designing database tables

I think database tables can be designed just by studying the information that will be needed to be retrieved from the database. There may be exceptional cases where this technique will not work.

Example 1: Imaginary small Store Database

Products in store, product detail, sales record, profit.

products(pid, name,quantity, unit: carton, box, individual, package, packet,bottle),total units)

product_detail1(pid,price,discount)

product_detail2(pid,property,value,unit) [property could be weight, power, current, volume, concectration, size, etc.]

sales(sid,date,time,pid,quantity,mp,sp)

profit(sid,profit)

Example 2: A Database for Imaginary Library

List of all the books, book detail, book usage history, book status,  list of users, library cards, card detail, user detail, fines, total fines, late returns, books lost record, books recovered record, books stolen, etc.

library_books(lbid,bid)

books(bid,title,authors_id,ISBN,Edition)

authors(authors_id,name,order)
[one row for each author]

book_detail(bid,publisher,date,price)

book_usage(usage_id,lbid,userid,date,time,action:(taken,returned,late return,lost,damaged,recovered))

book_status(lbid,status:(good,damaged,old,lost,stolen)

users(userid,name)

cards(userid,cardid)

card_detail(cardid, created_date,expiry_date)

user_detail(userid,address1,address2,phone_number,email,total_pending_fines)

fines(usage_id,fine_amount)

{Total fines can be evaluated from user_detail}

{Remaining informations can be retrieved from book_usage table}

Optional tables:
late_return(lbid,userid,date,time,delay)
books_lost(lbid,userid,date,time)
and so on...