1 / 1 / 0
Регистрация: 01.11.2017
Сообщений: 128
|
|
1 | |
ER диаграмма24.01.2019, 17:30. Показов 1344. Ответов 5
Метки нет (Все метки)
A parcel shipment society wants to build its database.
- The society deals parcel shipments. Parcels are identified by a code, and are characterized by weight, size and a category (e.g., fragile, refrigerated). For each parcel, sender and receiver clients are known. - Clients are identified by their SSID (unique for each person), and are characterized by name, surname, residence address and nation of birth. - For each package the desired service is also known. Services are identified by a code, and characterized by a commercial name, and a list of characteristics. - The society has employees. Employees are identified by their SSID, and characterized by name, surname, address and phone number. Among the employees there are drivers. Drivers are characterized also by type, number and expiration date of their driving licence. - The society has a set of offices all over the world. Each office has an unique id, and is characterized by city, nation, address and phone number. Employees work in an office. Each office has a supervisor, which is one of its employees. - The society has a set of trucks for the deliveries. Each truck is identified by an unique ID, and it is characterized by the maximum load size, and the category of parcels that can be delivered. The database tracks the drivers that have driven each truck, storing the dates in which he/she has driven it. It is also needed to store information about the truck which delivered each parcel, storing the dates and hours of shipment. - Each parcel traverses different offices before arriving at destination. The database keeps information about the offices traversed by a pack, keeping date and hour of leaving and date of hour of arriving of the parcel in each office. Прошу помочь.Желательно в формате как на фото. https://ibb.co/3Wtk3mL Все мои молитвы будут направлены и адресованы вам! Я очень нуждаюсь в вашей помощи, друзья!!
0
|
24.01.2019, 17:30 | |
Ответы с готовыми решениями:
5
Векторная диаграмма токов и топографическая диаграмма напряжений Диаграмма Диаграмма ER-диаграмма в VB |
Модератор
|
|
24.01.2019, 19:20 | 2 |
для ясности --гугл в помощь
0
|
1 / 1 / 0
Регистрация: 01.11.2017
Сообщений: 128
|
|
24.01.2019, 21:30 [ТС] | 3 |
Вот мною проделанный вариант. Пожалуйста, помогите.
Добавлено через 1 час 29 минут shanemac51, Последнее добавленное не относится к моему вопросу.
0
|
8860 / 5908 / 585
Регистрация: 27.03.2013
Сообщений: 19,572
|
|
25.01.2019, 02:01 | 4 |
Ситуация чем то похожа на поговорку -
"Не желай добра, не получишь зла".
0
|
1 / 1 / 0
Регистрация: 01.11.2017
Сообщений: 128
|
|
25.01.2019, 12:20 [ТС] | 5 |
VinniPuh, Не понял юмор.
0
|
8860 / 5908 / 585
Регистрация: 27.03.2013
Сообщений: 19,572
|
|
25.01.2019, 14:48 | 6 |
Не по теме: это я так, о своем, о женском. Изучайте не только Аглийский, но и Русский тонкий юмор.
0
|
25.01.2019, 14:48 | |
25.01.2019, 14:48 | |
Помогаю со студенческими работами здесь
6
Диаграмма ER диаграмма ER-диаграмма Диаграмма Искать еще темы с ответами Или воспользуйтесь поиском по форуму: |