Question: Work to be done The project is to be done in pairs. Therefore, groups of three people are not allowed. If your class has an

Work to be done The project is to be done in
Work to be done The project is to be done in pairs. Therefore, groups of three people are not allowed. If your class has an odd number of students, one and only one group of three is allowed. The final creation of the groups and the assignment will be done at the end of the second session. 1. Definition of the conceptual data model From the statement, express a conceptual data model using the entity-association model formalism to allow the E-commerce company to manage inventory for their online sale. 2. Definition of the relational model and implementation with a DBMS You will deduce, from the proposed modeling, a relational model of the database, by specifying in a concise and precise way the passage to relational. Then, you will implement the relational schema with a DBMS of your choice. You will define the domain constraints. You will insert, in the database, a minimum number of tuples, but sufficient to illustrate the possibilities of the application and test the queries 3. Predefined query requests You will propose, at least, 10 relevant queries of various difficulties in relation to the general application, and you will give the expression in SQL. The queries can be stored as a view or as a text file, so that they can be reused

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!