A data dictionary is the plan for creating a database. This plan is an essential

Question

A data dictionary is the plan for creating a database. This plan is an essential component of preparing for and creating a database. Read the information about planning a database, and then complete the discussion.

Imagine you are a chairperson for a service club, such as a volunteer or community service organization. One of your responsibilities is to create a database that will hold information about the club's members. Prior to building the database, decide what type of reports you would like to see on the members. This will help you decide what type of data you want in your database.

After considering the types of reports you would like to see:

Explanation / Answer

CREATE TABLE member_info ( serial_no int(255), member_id INT(100), member_name char(100), member_age varchar(100), member_address varchar(100), member_expirydate varchar(100), additional_posts_held char(100)' dues_levied int(100) ) -member_id will help to distinguish the members even if they have same name. -Expiry date will help to inform the members about payment of membership fees. -Additional posts will help to find out who the secretary is and other such data. -Address and age provide addtional data about the member

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.