Post reply

Basic Database Structure

  • February 9, 2011 at 1:51 am

    #231630

    Hi all,

    What Considerations do we need to take for a Basic Database Structure. We have a New project its an Online Food Order Management System, I have assigned for the Basic Database Structure for that project. As i have only 1 year of experience as a SQL Server DBA. I dont have much idea on this. Can any one help me out on this. For this project we are decided to use SQL Server 2008 Express Edition.

    Thanks in advance,

    OMeswar Reddy Danwada

  • February 9, 2011 at 2:07 am

    #1284268

    What do you mean with basic database structure?

    Best practices regarding table design? Column data types?

    Indexes? Normalization?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 9, 2011 at 2:12 am

    #1284272

    As this is for whole project i need it for every thing.

  • February 9, 2011 at 2:21 am

    #1284274

    Well, that is quite a lot to mention in one forum thread 🙂

    I think it is best that you search this site and the net for interesting articles on the subject.

    And maybe grab a book on database design and principles. (You can start with Codd and CJ Date).

    If you have specific questions, you can always ask them here.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 9, 2011 at 2:26 am

    #1284276

    Thanks for u r suggestion, I have asked primarily on which topics do we need to consider for a database structure.

  • February 9, 2011 at 2:37 am

    #1284283

    odanwada (2/9/2011)

    Thanks for u r suggestion, I have asked primarily on which topics do we need to consider for a database structure.

    I'd start with designing Entity/Relationship diagrams (E/R diagrams), normalization and data types.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 9, 2011 at 3:13 am

    #1284301

    Suhas Should JimB01979 use below command?

    BACKUP LOG P TO DISK = 'NUL'

    with proper considerations.

    JimB01979 After this command actually your log will not backup they will be discarded.

    Thanks

  • February 9, 2011 at 3:21 am

    #1284305

    forsqlserver (2/9/2011)

    Suhas Should JimB01979 use below command?

    BACKUP LOG P TO DISK = 'NUL'

    with proper considerations.

    JimB01979 After this command actually your log will not backup they will be discarded.

    I'm afraid you posted this in the wrong thread 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 9, 2011 at 3:28 am

    #1284306

    hi,

    i am going to develop a website for Online Food Order Management System that contains Users, Restaurants,Menus, Credit Card info etc.. and i have to prepare the database structure documentation. if any body knows how to prepare that database please help me and if u have any sample documents please send me to my mail id is omesh@gmail.com.

    Thanks in Advance.

    Omeswar Reddy Danwada

  • February 9, 2011 at 3:29 am

    #1284307

    hi,

    i am going to develop a website for Online Food Order Management System that contains Users, Restaurants,Menus, Credit Card info etc.. and i have to prepare the database structure documentation. if any body knows how to prepare that database please help me and if u have any sample documents please send me to my mail id is omeshmca@gmail.com.

    Thanks in Advance.

    Omeswar Reddy Danwada

  • February 9, 2011 at 6:25 am

    #1284395

    You're unlikely to get someone to do your work for you for free. Instead, you shoul focus your efforts on the things that people have already suggested. Learn about entity relationship models, normalization rules, etc. I'll add a couple of other things you should focus on. First, as you develop your database, get it into Source Control (if you don't know what that is, ask your development team. If they don't know... you're in trouble). Next, learn about backups. How to do them, how to automate them, and, most importantly, how to recover them. Guaranteed, you or one of the developers will mess something up at some point and you'll need to recover from a backup.

    Might I suggest an introductory book on SQL Server? My book "Beginning SQL Server 2008 Administration" will help you some.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply