Create an ER-model and a relative model from a database
The task is to design the ER model of the future automated information system (AIS).The subject area of the system, the functional requirements of the system and the types of users of the system will be selected independently.1 .The ER model must contain: at least 5 essential and non-obligatory attributes at least one derivative attributes at least one complex attributes at least one multi-significant attributes must be at least one connection of shortness n:m and several connections of shortness 1:n at least one recurrent connection 2.A comment on the ER-model to indicate the formulas of the calculation of each output attribute.Example: term_day_contract = date_depletion_contract - date_signature_contract.3 .With a comment on the ER model to specify all corporate data integrity limits.Example: age of employee = 18 years.and 4.The number of types of AIS users must be not less than 2.Example of the finished model - Supermarket.png
It is desirable to take the foundation of something else, not a supermarket, it can be a bar, restaurant, etc.Per with some of your own characteristics, you will get to your own mind.Relational to this ER-model.This will be a table(The ready empty table for this task is attached).An example of the building is in the Library_ER_RM file(An example of filling the table of the description of the relational model (“Bibliothèque”)).Additionally, the general rules for the translation of any ER model into the relative are also attached.
Applications 4
Client's review of cooperation with Vladyslav Y.
Create an ER-model and a relative model from a databaseThe project was performed well and in a short time. I recommend this executive.
Freelancer's review of cooperation with Oleg Rusak
Create an ER-model and a relative model from a databaseIt’s great, I recommend cooperation.
Current freelance projects in the category Databases & SQL
Development of Backend core (Python), Telegram FSM engine, and Stripe integrationWe are looking for an experienced Backend Developer (Middle/Senior) to create an independent Headless core for an EdTech product. The system operates on a strict monthly subscription model. The core logic must be completely isolated from the content. All development is conducted… Python, Databases & SQL ∙ 1 hour 17 minutes back ∙ 5 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 hours 13 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 9 hours 44 minutes back ∙ 28 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 18 hours 19 minutes back ∙ 34 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 13 hours back ∙ 16 proposals |