A start-up company is assembling customized stereo ear-buds. Instead of shipping

Question

A start-up company is assembling customized stereo ear-buds. Instead of shipping dozens of different sizes and shapes of in-ear pieces, the company distributes a clear piece of plastic with various marks. Customers hold the piece on their ear and take a photograph. A system at the company reads the markings and determines the best ear-piece for each customer. The assembly team then builds the custom ear-buds for the customer allowing them to set additional specifications including colors, logos, number of "armatures" or speaker cones, and control switches for android or Apple devices. The company needs a database to track orders, assembly, and shipping Referrer/Source Customer Last name, First name Phone, e-mail Address City, State, Postal Code Country Left Ear Right Ear Measure Photo Horizontal Distance Vertical Distance Depth Color Wire color/type Logo Armatures Apple/Android Assembly Date Work station # Employee Name, Date Hired, Title Customer Order ID tem ID Quantitv Comments Start Time End Time Comments/ Changes Inspector ID, Supervisor Value Pass/Fail Test Audio low Audio high Stretch Inspection outcome

Explanation / Answer

CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);

CREATE TABLE Orders (
    OrderID int NOT NULL PRIMARY KEY,
    OrderNumber int NOT NULL,
    PersonID int FOREIGN KEY REFERENCES Persons(PersonID)
);

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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