Homework answers / question archive / implement Relational Database a

implement Relational Database a

Computer Science

Share With

---

implement Relational Database

a. Develop the SQL scripts that will create the tables and enforce all the appropriate constraints.

b. Develop sample SQL scripts that will insert the data to the database sufficient to populate:

® one sales invoice with at least two options and one trade-in

« two service invoices - one for the car sold and one for another

= one sales supplement for the sales invoice

= one vehicle inventory record

= three prospective customer interests

c. Develop sample SQL scripts that will:

= create a VIEW to support a sales invoice

= create a VIEW to support a service invoice

= create a VIEW to support a sales supplement

= create a VIEW to support a vehicle inventory record

= create a prospect list and one other report

4. NoSQL DataBase

a. Convert at least 2 entities to MongoDB Collections. You will need to provide justification on why did you choose the entities. Create the collection(s)

Develop sample code that writes documents to the collections (one or two documents per collection based on documents in the relational database)