TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
shrish pulkit
NA
8
3.5k
Designing Database Table for Navigation Menu
Jun 22 2015 7:26 AM
Hi i have been working on a online shopping project for gifts .
My Navigation menu has 3 Levels like this :
Parent Menu ==> Child Menu ==> Child Sub Menu .
Reference Image Attached.
http://tryourself.com/m1.png
i have to get all these values from the database table in a hierarchy, i was thinking to design the database table in such a way that request time for fetching menu data from table is minimal.
my idea is to design a table name navigation_menu with following parameters : id(as menu id),
Menu_Name
,
Parent_id
id(Parent Menu id)
Menu_Name
Parent_id
0
BIRTHDAY
-
1
OCASSIONS
-
2
GIFTS
-
3
SPECIAL
-
4
CAKES
0
5
OFFERS
1
6
GIFTS
0
7
SPECIAL CAKE
4
8
PHOTO CAKE
4
Or can i design the database in a better way to fetch the data more faster
(Suggestions required)
.
Reply
Answers (
2
)
how to display google api map in mvc5 application
need to implement auto dialer feature in asp.net