Job Description:

Statement of the project

An E-commerce company wants to set up a database managing the stocks of their online sales (it can be specialized in clothes, books, household appliances, interior decoration...). To organize the online store, the company defines a catalog of categories where each category has one or more products.

However, a product can only belong to one category at a time.

At the supply level, the same product can be purchased from different suppliers. A customer can place one or more purchase orders that will be delivered on a specific date. A purchase order is composed of one or more products where for each one, a discount can be defined (in percentage of the selling price). Any purchase order can be delivered at once but a delivery can contain several purchase orders.

The database will respect the following business rules:

● The delivery date of a delivery note must be on or after the order date.

● For a given product in a purchase order, the sum of the quantities of the associated deliveries must be less than or equal to the quantity of the purchase order.

● The sum of the products to be delivered cannot exceed the quantity in the stock.

Work to be done

The project is to be done per group of 3 students. Therefore, groups of four people are not allowed. If your class has a number of students not divisible by 3, one or two groups of 2 are allowed.

The final creation of the groups will be finalized at the end of the second class.

1. Definition of the conceptual data model

From the statement, express a conceptual data model using the Entity-Association model 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.

Project progress and deadlines

This project will result in a clear, concise and comprehensive report, containing at least the following sections:

▪ The definition of a data dictionary describing the entities of the schema, the details of each entity and the relationships between them.

▪ The precise description of the transition to the relational model. No more than two pages of explanation.

▪ The SQL script to create the database schema.

▪ The expression in English and in SQL of the predefined queries (see item 3 of the assignment).

▪ A conclusion describing the limitations of your work, as well as an estimate of the time spent per person and the distribution of tasks. You should spend no more than 10 hours per person on this project.

It is not necessary to put the script of insertion of tuples.

Although comprehensive, your report should remain sober: avoid overly convoluted presentations and unnecessary speeches. Comments should introduce, highlight and justify your work. Be concise.

The report is due on Friday, Mars 17th, 2023 before 12am. Please write legibly the name of each member of the group on the cover of your report.

An oral defense, only on the SQL code of the schema and the queries will be done, during the last session: the week of the 20/03. The project will have to be finished by this date.

The objective of the defense is to verify the progress of the work and the involvement of each member of the group in the project.

Aptitudini: MySQL, Software Engineering

Despre client:
( 0 recenzii ) France

ID Proiect: #36206879

14 freelanceri licitează în medie 137€ pentru acest proiect


Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on MySQL, Software Engineering Lets connect in chat so t Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(33 recenzii)

MASTERS IN SOFTWARE DEVELOPMENT AND ARCHITECTURE. Hi there! I have carefully read the project description and I would like to take part in this project. I will work according to your requirement to provide the best qua Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 5 zile
(9 recenzii)

Hello. How are you. I've worked with another client in the space. And i think you might find it very interesting to have a chat. I will be proven me and deliver the good result with low budget and good result. Hope to Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(2 recenzii)

I have checked your document and i can do the project as you want and give by your due date Let me know more about it I am a freelancer with having 6 years of experience. I've gone through your project. I have read Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(7 recenzii)

Greetings I'm a data engineer with extensive experience in databases and SQL. I'm confident that I can deliver high-quality work within your budget and timeframe. Let's discuss further. Mounir

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(3 recenzii)

I have carefully gone thorough your description and understand what you want And I am glad to inform you that I have relevant strong experience in Database design and have worked on many similar projects before. I can Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(2 recenzii)

• Proficient in Advance Excel, Power BI, SQL and Python. • Knowledge of data visualization tools such as Tableau, Python and Power BI. • Experience with statistical analysis and predictive modelling techniques. • Stron Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(1 părere)

Hello! I am an expert Swift developer with skills including Software Engineering and MySQL. Please send a message to discuss more about this project. Thanks & regards

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 3 zile
(0 recenzii)

Thanks for stopping here. I'm Marina, a senior software engineer with 7+ years of experience in MERN Stack Development. I've just checked this project carefully and I think I'm well suited to this, bcoz my expertise an Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 4 zile
(0 recenzii)

This is doable in a day. Do you want help doing it yourself or do you want someone to do it for you? Overall looks like you need an outline of the database, queries to pull information and build the db, and documentati Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR în 1 zi
(0 recenzii)

Hi there i can do and have done this type projects as i am a database developer. I can share my previous works with you. I have gone through your requirement file. lets discuss it in details over the chat.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% EUR în 7 zile
(0 recenzii)