Results 1 to 3 of 3
  1. #1
    green369 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2020
    Posts
    5

    Want to create a database for aquaculture farm and export of shrimp

    Dear Friends,



    I am new to the database i want to Create a database which can track the quantity produced from aquaculture farm exported to which country I have made just outline of the tables which needed upto my knowledge but i was stuck how to put relationships for tables so that the design is more stable to my work

    I have attached the excel file having tables details and the fields for each table


    the work flow will be order entry with exporter name, buyer name, order number, country, shipment date, order details with order id, certification, brand, variety, packing style, grade, no of packets. The order is assigned to codelist. codelist have CodeList details where we will select one of The order details from order in codelist for which we will assign farmid, pond number, no of packets produced, production date. The details of the farmid and pond number which we given in codeListDetails table should be reflect in pondTable.


    Finally i want the output from this database as when i query i have to get the
    1.Orders based on ordernumber,
    2.Details of the FinishedProductQTY based on ProductCategoryID & CertificationID
    3.Details of the HarvestedQTY based on CertificationID


    kindly help me with this it would be very helpful

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,752
    You have identified data entities and designed a schema which looks reasonable. Now start building.

    Advise not to use all upper case in naming convention (except maybe for FCR because that must be an acronym).
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    madpiet is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Feb 2023
    Posts
    97
    One thing that's helpful to do is to create your queries to answer your most important business questions before you build the UI. If you find you cannot answer a business question, then it may mean your design isn't quite right. It's a lot easier to fix before you start building forms etc "on top of" your tables. Your design looks okay. Not a huge fan of the IDs on everything (like value lists... I just think that's overkill, but you do you.)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 11-28-2017, 11:25 AM
  2. Working on creating a database of meat cuts for our farm
    By Farmer Bill in forum Database Design
    Replies: 18
    Last Post: 03-19-2017, 06:27 PM
  3. How to Create Export Specification?
    By kagoodwin13 in forum Programming
    Replies: 3
    Last Post: 07-27-2016, 01:24 PM
  4. Replies: 14
    Last Post: 12-28-2015, 07:51 AM
  5. Replies: 4
    Last Post: 06-04-2014, 01:25 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums