our notes for our youngers

March 9, 2010

Simple Book Store (Part 1)

Filed under: ASP.NET — sevenlamp @ 11:08 AM

Simple Book Store

ကြၽန္ေတာ့္ကို Cbox ထဲမွာ ကိုေဇာ္လင္းခိုင္က “Book Store တစ္ခုအတြက္ Database Table ေတြ ဘယ္လိုေဆာက္ရမလဲ” ဆိုျပီး ေမးထားတဲ႔ ေမးခြန္းတစ္ခု ရွိပါတယ္။ ဒီလိုပဲ ကိုနိုင္ေအာင္ ကလည္း Comment တစ္ခုမွာ “ASP.NET ကေန Database ကို ခ်ိတ္ဆတ္ပံုေလး ေျပာျပေပးပါ” လို႔ ေမးထားပါတယ္။ ဒီေမးခြန္း ၂ ခုကိုလည္း ေျဖရင္းနဲ႔ ကြၽန္ေတာ္ Simple Book Store Program ေလးတစ္ခု တည္ေဆာက္ျပခ်င္ ပါတယ္။ ဒီ Program ေလးမွာ အဓိက အပိုင္း ၂ ပိုင္း ပါ၀င္ပါတယ္။ Book List နဲ႔ Book Entry ေပါ့။

Database Normalization

Normalization လုပ္လို႔ ေကာင္းတဲ႔ အခ်က္ေတြကိုေတာ့ SQL Server Book Online ထဲမွာ ဒီလို ေျပာထားပါတယ္။

Some of the benefits of normalization include the following:

  • Faster sorting and index creation.
  • A larger number of clustered indexes.
  • Narrower and more compact indexes.
  • Fewer indexes per table. This improves the performance of the INSERT, UPDATE, and DELETE statements.
  • Fewer null values and less opportunity for inconsistency. This increases database compactness.

read more…

1 Comment »

  1. ညီေရ

    Simple Bookstore Part 1 မွာ read more ကိုႏွိပ္လိုက္ရင္ co.cc ရဲ႕ေၾကာ္ျငာကိုေရာက္ ေရာက္သြားတာယ္ အဲဒါေလး တစ္ခ်က္ျပန္ၾကည့္ေပးပါအံုးေနာ္

    Comment by Oo Ko — July 12, 2015 @ 4:16 PM


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: