vivid shell
I have an school project where i need to create an ERD using a one to one relation. But i dont realy understand what i need too do, if there is anyone that has the time to help me please respond. Greetings Stijn. Here is my task ➡️ All common data for the user is recorded in the users table. It was decided to record the specific data for each role in a separate table. Each user can only have one of these roles.
An ID, first name, prefixes, last name, gender, email, username and password are recorded for each user, as well as the street, house number, zip code, city, country, telephone number and mobile number. For the administrator, it is still recorded when the person is employed. The manager's department and the number of people in that department are kept separately for the manager. For the regular it is recorded as of when (date) the regular user has become.
Explanation functionality 2:
All addresses are recorded in one table. This is one table with all addresses used in the organization. The addresses of the users themselves are also stored in this table (so not in the users table). Only one address of each user is recorded and each address can only belong to one user. If an address does not belong to a user, then it concerns an address of someone outside the organization (not a user).
For an address, a description, street, house number, zip code, city, country, telephone number, mobile number, note and an addition date are recorded.
Explanation functionality 3 and 4:
Both overview pages must have a search and sort functionality. Users can search for addresses based on description, phone number or other relevant information. In addition, they can sort their addresses by description or date added. On the overview page with users, all data of a user is shown per user, including the specific data. On the overview page with addresses, an administrator and manager can see all addresses, but a regular can only see the addresses without those of the users.
thorny scroll
proud zodiac
