What are the steps to create data dictionary

Question

1.00/5 (1 vote)

See more:

Hello,

this is my first project in IT.i start with analysis but in database i want to create data dictionary.my project is about online pharmacy ,where user can order medicine online.

What I have tried:

i tried to analys my website but everything is mixup.

Posted 4-Jan-22 7:30am

harsha lohana

Updated 4-Jan-22 23:12pm

Add a Solution

Comments

0x01AA 4-Jan-22 13:43pm

You need to be more specific and very important you need to be consistent using terms.

E.g. dictionary:
A dictionary has at least one 'key' and a 'value' for that 'key'. Very simple so far.
Of course one can extend that dictionary that one key can have multiply values. Think about a dctionary which supports translation from english to french, spanish, whatelse.

Such a dictionary you can then extend to something which allows you finally to translate from language x to language y.

So try to describe more precise what you need and also what you tried ;)

[no name] 4-Jan-22 18:02pm

For a "data dictionary", you can use Excel: one sheet per table; rows for fields; columns for attributes (name, type, size, etc). Use color for hiliting keys, etc.

Prototype in Access, maybe. The printed table definitions make for a data dictionary of sorts.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Asif_ · Answer 1 · 2022-01-04T23:12:00

Data Dictionary in Application Database is a document usually in excel sheet that elaborates the entire schema.

You need to write all tables and their columns along with their business purpose, relations, etc. You can add more details like indexes if you want.

You can also use below template
Data Dictionary - Examples | Ag Data Commons[^]