It is a record of metadata about an actual data. It may be manually defined with the elements of system, processes and storage of data.
It provides additional information about the system. The data dictionary is developed during system analysis phase which involves different system requirements. If the system analyst wants to know how many characters are represented in a data item, by which different names it is referenced in the system is properly managed by developing data dictionary. These elements of data are organized in a well structured manner to meet user request and organization needs. It is a common source of definitions for the users and investigations. Data dictionaries are an integral component of structured analysis as they fully describe the project activities. It also manages the details in a large system.
Why is Data Dictionary Important?
Analysts use data dictionaries for five important reasons… To manage the details in the large systems
To communicate a common meaning for all system elements To document the features of the system
To facilitate analysis of the details in order to evaluate characteristics and determine where system changes should be made. To locate errors and omissions in the system
Data Dictionaries are an integral component of structured analysis, since data flow diagrams by themselves do not fully describe the subject of the investigation. The data dictionary provides additional information about the system.
Table Name: Customer Primary Key: C_id
Description: It stores the information of the customer (buyer or seller).
Field Name Data type Description
c_id int Primary Key
user_cat nvarchar(MAX) Stores the category of the user user_type nvarchar(MAX) Stores the type of user
f_name nvarchar(MAX) Stores the first name of the user l_name nvarchar(MAX) Stores the last name of the user nmail_id nvarchar(MAX) Stores the email id of the user username nvarchar(MAX) Stores the username of the user password nvarchar(MAX) Stores the password of the user country nvarchar(MAX) Stores the country of the user state nvarchar(MAX) Stores the state of the user city nvarchar(MAX) Stores the city of the user
mobile1 numeric(18,0) Stores the mobile no. of the user mobile2 numeric(18,0) Stores the mobile no. of the user
price_min numeric(18,0) Stores the minimum price range of the required property
price_max numeric(18,0) Stores the maximum price range of the required property
country_code numeric(18, 0) Stores the country code city_code numeric(18, 0) Stores the city code phone_no numeric(10, 0) Stores the pone no
Topic No. 5.3 DATA DICTIONARY
Primary Key: Prop_id
Description: It stores the information of the respective property. Field Name Data type Description
Prop_id int Primary Key
C_id int Foreign Key
Cat_id int Foreign Key
Title nvarchar(MAX) Stores the title of the property Price numeric(18, 2) Stores the price of the property
Country nvarchar(MAX) Stores the country in which property is located
State nvarchar(MAX) Stores the state in which property is located City nvarchar(MAX) Stores the city in which property is located Rooms numeric(18,0) Stores the no of rooms of the property Beds numeric(18,0) Stores the no of beds rooms of the property Furnished nvarchar(MAX) Stores the if property is furnished or not Longitude decimal(18, 7) Stores the Longitude of the property Latitude decimal(18, 7) Stores the Latitude of the property
Area numeric(18, 0) Stores the area of the property in sq. feet Type nvarchar(50) Stores the type of the property
Image nvarchar(MAX) Stores the outer image of the property Thumbnail1 nvarchar(MAX) Stores the interior of the property Thumbnail2 nvarchar(MAX) Stores the interior of the property Thumbnail3 nvarchar(MAX) Stores the interior of the property Thumbnail4 nvarchar(MAX) Stores the interior of the property
Small_desc nvarchar(MAX) Stores the small description of the property Description nvarchar(MAX) Stores the description of the property
Date1 nvarchar(MAX) Stores the current date of when the property was uploaded
Topic No. 5.3 DATA DICTIONARY
Table Name: Admin Primary Key: Ad_id
Description: It stores the information of Admin. Field Name Data type Description
Username nvarchar(50) Stores the username of the Admin Password nvarchar(50) Stores the password of the Admin Phone numeric(18, 0) Stores the phone number of the Admin Email_id nvarchar(50) Stores the email_id of the Admin
Table Name: Home_categories Primary Key: Cat_id
Description: It stores the information of Home Categories. Field Name Data type Description
Cat_id int Primary Key
Cat_name nvarchar(50) Stores the name of the Category
Topic No. 5.3 DATA DICTIONARY
Table Name: Payment Primary Key: P_id
Description: It stores the information of Payment. Field Name Data type Description
P_id int Primary Key
Prop_id int Foreign Key
C_id int Foreign Key
Price numeric(18, 0) Stores the price of the property sold
Buy_date date Stores the date when the property was sold
Buy_time time(7) Stores the time when the property was sold
Payment_Status nvarchar(MAX) Stores the payment status of the property
Table Name: Countries Primary Key: Country_id
Description: It stores the information of Countries. Field Name Data type Description
Country_id int Primary Key
Country_name nvarchar(MAX) Stores the name of the Country
Topic No. 5.3 DATA DICTIONARY
Table Name: States Primary Key: State_id
Description: It stores the information of States. Field Name Data type Description
State_name nvarchar(MAX) Stores the name of the State
Table Name: Cities Primary Key: City_id
Description: It stores the information of Cities. Field Name Data type Description
City_id int Primary Key
City_name nvarchar(MAX) Stores the name of the City
Table Name: Email Primary Key: Em_id
Description: It stores the information of Emails. Field Name Data type Description
Em_id int Primary Key
Sender nvarchar(50) Stores the name of the Sender Receiver nvarchar(50) Stores the name of the Receiver Subject nvarchar(MAX) Stores the subject of the email Body nvarchar(MAX) Stores the body of the email
Em_date datetime Stores the date and time of the email when it was sent
Topic No. 5.4 RECORD LAYOUT
R
ecord
L
ayout
Table Name: Customer
Description: It stores customer details. Primary Key: C_id
Topic No. 5.4 RECORD LAYOUT
Table Name: Properties
Description: It stores Property details. Primary Key: Prop_id
Table Name: Home Categories
Description: It stores Home categories. Primary Key: Cat_id
Topic No. 5.4 RECORD LAYOUT
Table Name: Payment
Description: It stores payment details. Primary Key: P_id
Table Name: Email
Description: It stores email details. Primary Key: Em_id
Table Name: Admin
Description: It stores admin details. Primary Key: Ad_id
Topic No. 5.4 RECORD LAYOUT
Table Name: Countries
Description: It stores the countries along with the country_id and country_name. Primary Key: Country_id
Topic No. 5.4 RECORD LAYOUT
Table Name: States
Description: It stores the states along with the country_id,state_id and state_name. Primary Key: State_id
Topic No. 5.4 RECORD LAYOUT
Table Name: Cities
Primary Key: City_id
Topic No. 6.1 SCREEN SHOTS