A mobile product manager wants to build a database to track the team\'s mobile p

Question

A mobile product manager wants to build a database to track the team's mobile products. a. Write the SQL Script to create the table for a Product which needs to contain Productld (PrimaryKey), Product Name, Product Type (Which can only contain the values "Utility", "Social" or "Game"), Priority and Delivery Also, write the SQL Script to create the table Developer which contains the Developer's ID (Primary Key), SSN, First Name, Last Name CountryofBirth, Birth Date, Job title, Bonus Amount and the Product ID of the product being developed by the developer. In addition, Review the requirements below: (20pts). Add a foreign key to ensure the relationship between the tables Last Name) are NULLABLE. can only work on one product. ii. All columns EXCEPT the lds and names (Product Name, First Name and iii. A Product can have multiple developers working on it, but a developer

Explanation / Answer

If you have any doubts, please give me comment...

CREATE TABLE Product(

ProductID INTEGER NOT NULL PRIMARY KEY,

ProductName VARCHAR(50) NOT NULL,

ProductType VARCHAR(20),

Priority INTEGER,

DeliveryDate DATE

);

CREATE TABLE Developer(

DeveloperID INTEGER NOT NULL PRIMARY KEY,

SSN INTEGER,

FirstName VARCHAR(50) NOT NULL,

LastName VARCHAR(50) NOT NULL,

CountryOfBirth VARCHAR(50),

BirthDate DATE,

JobTitle VARCHAR(100),

BonusAmount REAL(10,2),

ProductID INTEGER,

FOREIGN KEY(ProductID) REFERENCES Product(ProductID)

);

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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