Basic Database Structure

  • 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

  • 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

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

  • 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

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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