PLEASE HELP! A use case diagram with 5 use cases, including actor (stick figure)

Question

PLEASE HELP!

A use case diagram with 5 use cases, including actor (stick figure) and process (bubble). Each bubble should include an identifying phrase.

A description/definition of each use case, keyed to the identifying phrase used in the process bubble.

A data model with 5 classes and 4 relationships. Label the classes and relationships.

List 5 attributes for each class. Indicate which is the primary key.

List cardinalities on both ends of each relationship.

Create 5 SQL triplets. A triplet is

A natural language question or statement.

A SQL query answering that question or statement.

A results table returned from the query.

Create one each of these types of SQL trilogy:

SELECT . . . FROM . . .

SELECT . . . FROM . . . WHERE

SELECT . . . FROM . . . WHERE . . . ORDER BY

SUBQUERY

JOIN

---------------------------------------------------------------------

Using:

Exmaple:

Name Robot Sensors Robotics Computing Materials Titanium Alloys Dynamic Systems Finances Albert Richard Claude Neil deGrasse Einstein Feynman Los Angeles Shannon Princeton NJ 101 102 103 104 105 NULL NULL NULL 104 Cambridge yson New York Palo Alto 107 NULL Question Description What government programs could help fund the robotics projects? What's the best database to use to keep track of researchers and projects? 201 102 203 What should we make the elevator walls out of? 104 204 How do we make the elevator stop when something unexpected goes wrong? 205 What material is strong enough to hold up the payload but flexible enough to bend in the wind? 105 Project 301 302 303 Elevator Auto-Brakes Sensors Preliminary Elevator Auto-Brakes Sensors Stage I Alloy Tensile Strength Database Exploration Project Alexandria Database Implementation Plastics Resilience Testing 204 204 203 202 202 203 2009 2012 2010 NULL 403 305 2011 NULL 405 306 2010 Document 401 What Slows What? Deceleration 2005 106 103 104 Pros and Cons of Databases Computing Today Nanotech Review 2011 403 Alloys and Their Tensile Strengths 2012 How to Finance Big Projects Melting Points of Plastics Elevator Auto-Brake Preliminary Study The All-Seeing Robotic Eye 2008 2012 2011 2011 104 101 101 407 McGraw Hill Yes Yes 403 No 401 403 407 407 405 Yes Yes 12 Yes Yes

Explanation / Answer

Here the SQL Queries are correct...

What did you expecting from this question? Please give me comment.... Thank you

CREATE TABLE Personnel(

PerID INT NOT NULL PRIMARY KEY,

fName VARCHAR(50),

lName VARCHAR(50),

hCity VARCHAR(100),

hState CHAR(2)

);

CREATE TABLE SubjectArea(

SubID INT NOT NULL PRIMARY KEY,

Name VARCHAR(100),

parSub INT,

FOREIGN KEY(SubID) REFERENCES SubjectArea(SubID)

);

CREATE TABLE Question(

QuesID INT NOT NULL PRIMARY KEY,

Description VARCHAR(255),

SubID INT,

FOREIGN KEY(SubID) REFERENCES SubjectArea(SubID)

);

CREATE TABLE Document(

DocID INT NOT NULL PRIMARY KEY,

docDesc VARCHAR(255),

docPub VARCHAR(100),

docPubDate INT,

docSub INT,

FOREIGN KEY(docSub) REFERENCES SubjectArea(SubID)

);

CREATE TABLE Project(

ProjID INT NOT NULL PRIMARY KEY,

projDesc VARCHAR(255),

startDate INT,

repResult INT,

projQues INT,

FOREIGN KEY(DocID) REFERENCES Document(DocID),

FOREIGN KEY(projQues) REFERENCES Question(QuesID),

);

CREATE TABLE ProjectMember(

ProjID INT NOT NULL PRIMARY KEY,

PerId INT,

leadPer VARCHAR(5),

FOREIGN KEY(PerId) REFERENCES Personnel(PerID)

);

CREATE TABLE DocContributor(

DocID INT,

PerID INT,

PRIMARY KEY(DocID, PerID),

FOREIGN KEY(DocID) REFERENCES Document(DocID),

FOREIGN KEY(PerID) REFERENCES Personnel(PerID)

);

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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