For each of the problem statements, do the following:a. Draw an ER diagram. Make sure each entity type has at least one key attribute.Document any assumptions you make. Avoid diagrams with a single entity.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 havelaunched into space. Data includes the satellite identification, date of launch, destruction date,purpose, maximum orbital altitude, launching location, launching agency, and contactinformation for agency.Problem 2: A psychological study requires participants to answer a number of questions relatedto personality. The database should store the multiple choice answers (A, B, C, D) to thequestions and information about each participant, such as participant id, age, and sex. Thedatabase should compute a score based on the individual’s answers. The score indicates one of 8personality categories. Each category has an identifying name and specifies that each of threequalities is either true or false.
We help you get better grades, improve your productivity and get more fun out of college!!
Get 25% Discount on Your First Order
How it works – it’s easy
Place your Order
Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.
Make a payment
The total price of your order is based on number of pages, academic level and deadline.
We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to make sure that the assignment meets all of your requirements.
Once complete, we’ll send your assignment via the email provided on the order form.