Assignment: For each of the problem statements, do the following: b. If you thin

Question

Assignment: For each of the problem statements, do the following:

b. If you think the description is incomplete, list other data the database should store.

c. Adjust your design to incorporate these additions.

Problem 1: A space agency wants to develop a database of all satellites that humans have launched into space. Data includes the satellite identification, date of launch, destruction date, purpose, maximum orbital altitude, launching location, launching agency, and contact information for agency.

Problem 2: A psychological study requires participants to answer a number of questions related to personality. The database should store the multiple choice answers (A, B, C, D) to the questions and information about each participant, such as participant id, age, and sex. The database should compute a score based on the individual's answers. The score indicates one of 8 personality categories. Each category has an identifying name and specifies that each of the qualities is either true or false.

What to turn in: • A softcopy of your answers. • No handwritten answers are accepted.

Explanation / Answer

Hello, I wrote all the tables required for database in Problem 1 and Problem 2.

If you need addition or more detail, please write the comment with full information detail what you actually want.

I will be there for help you. :)

Problem 1:

SatelliteTable
id integer primary key,
s_dol date   /*date of launch*/
s_dod date   /*destruction date */
s_purpose text,
s_max_orbital_alt float,
s_loc_lat float, /*lauch location latitude*/
s_loc_lon float, /*lauch location longitude*/
s_agency_name text

SatelliteContactTable
id integer primary key,
c_satellite integer, /*Satellite Id from Satellite Table*/
c_country varchar(50),
c_email varchar(100),
c_phone varchar(50)

Relationship: c_satellite is from SatelliteTable.id only

Problem 2:

QuestionTable
id integer primary key,
q_title text,
q_option_a text,
q_option_b text,
q_option_c text,
q_option_d text

QuestionAnswerTable(Relation with question and participants)
id integer primary key,
qa_qid integer, /*Question id from Question Table */
qa_pid integer, /*Participant id from Participant Table */
qa_ans varchar(1) /* option choosed by qa_pid for question qa_qid(a,b,c or d)*/

ParticipantsTable
id integer primary key, /*Participants id*/
p_age integer,
p_sex varchar(1), /*m or f*/
p_score integer /*For storing score according to answer */

ScoreCatTable
id integer primary key,
sc_name text /*Catagory identifying name */
sc_value   /*Score catagory value*/

/*It will store quality for each participants in 1 or more row*/
QualityParticipantsTable
id integer primary key,
qp_pid integer, /*Participants id from Participants Table.*/
qp_cat integer /*Catagory id from ScoreCatTable.*/

(qp_pid+qp_cat is unique key also)

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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