Reference no: EM13835110
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.
If you think the description is incomplete, list other data the database should store.
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 three qualities is either true or false.
|
Discuss ethical role of a manager in long-term care facility
: Discuss the ethical role of a manager in a long-term care facility when faced with a family decision to withhold nutrition and fluids to a terminal and semicomatose patient
|
|
Develop a simple website
: Develop a simple website. Show the home page of the Web site that the visitors can use to visit the site and about 5 more pages plus some figures. Also show the site map at two level of depth (i.e., what pages will be invoked from first page, etc). ..
|
|
Identify critical parts of a mobile device
: Identify critical parts of a mobile device that an examiner should examine. Explain what items of evidentiary value (i.e. images, internet history) can be recovered from the identified critical parts. The assignment should be 3-5 pages in content a..
|
|
Company originally repaired radios and household appliances
: Conch Republic Electronics is a midsized electronics manufacturer located in Key West, Florida. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founde..
|
|
Space agency wants to develop a database of all satellites
: 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, launchi..
|
|
Explain how subqueries and joins are interchangeable
: Explain how subqueries and JOINs are interchangeable. Provide SQL syntax examples. Upload your scenario, SQL query syntax, and a screenshot of the data results into the discussion board for review.
|
|
Plot a pareto frontier that maximizes q and minimizes p
: With the constraint for COP removed, plot a Pareto frontier that maximizes Q and minimizes P for each TE unit. Identify the point on each plot that corresponds to the maximum COP achievable by that TE unit.
|
|
Equal the purchasing power of her current earnings
: A client is concerned about the impact that inflation will have on her retirement income. The client currently earns $40,000 per year. Assuming that inflation averages 2.25% for the first five years, 2.5% for the next five years and 3.25% for the rem..
|
|
Describe the population you will use and why you chose them
: Paper done on pavlon experiments on children and Propose an alternative approach that would meet current ethical standards. Explain the methods you will use (addressing the ethical violation)
|