Search results

In essence it becomes / is similar to systems integration project - multiple (departmental) systems that need to exchange data. This may be done through the one database/ shared tables, however clear rules around which application is the owner of the data in the sense of right to create modify...

Did you inadvertently leave out a UAT environment when describing your process? - so the users have a chance to review/verify the functionality expected, implement and test urgent fixes and set up a change log and to get sign off from the users/project owner?

The input tables should be shared by users - not multiple versions. Each row in the table can have a column identifying the user (userID) that performed the input. You need a Login form to capture the userID. As advised by others - one BE database, multiple copies of the same front end for your...

My view is that there are some shortcomings in the data: Some items require redefining Leave ID (Primary key)\ Employee ID (is a lookup from the employee table) Employee name (is a lookup from the employee table) Not required – use the name in the employee table – don’t use a second copy –...

Like others who have responded this does appear a very odd constraint - to limit an employee to only working on one project. Perhaps the scope was not fully described / defined. There are at least two scenarios: 1. The model represents only the most recent / current allocation of employees to a...

Agree with @The_Doc_Man - unless there is some compelling reason for the Spanish DNI to be physically held separately, the Spanish DNI attributes belong with the Person. As no compelling reason has been given then combine them. The record of renewals / sighting, if history is needed, can be...

Addresses were geocoded to population areas - sometimes those boundaries changed. More recently adopted a longer-term level of standardisation: ASGC Mesh Blocks at the most fine-grained level Re the old passwords - encrypted, stored separately from the userprofile record - as the archived...

Exploring the case of a real 1:1 relationship: A database may be modelled to store the details of people/employees. It may also require that the users have a userprofile. The users as people may also be in scope of the set of people/employees. Not all people are users. You could merge the tables...

Let me preface this: the process of modelling data is both an art and a science (maths) involving discovery and iteration as business rules (explicit and implicit) are uncovered. There are many texts written on this that go much further, espousing methodologies and approaches, than will be...

Consider the mandatory/optional (participation) nature of the relationship to help determine if it is an identifying relationship. If the relationship to an entity is not Mandatory - then the relationship to that entity cannot be an identifying relationship. A 1:1 relationship would generally...

An ER or EER model is a visual representation of data and constraints and its relationships to other data. In both an identifying relationship is a relationship between two entities in which an instance of a child entity is identified through its association with a parent entity. The child...

Seems to me that, in line with @LarryE's comment on db structure, there is the question of can you identify those current employees that have not taken any training courses in the last two years. That question can be raised with whoever wants the report, and may illustrate the limitations of the...

https://en.wikipedia.org/wiki/Mass_shooting Various definitions.

Yet you do not define how you obtain Billto_xPTerms or BillTo_yRep. As this is referenced as Master Data are they PK/FK dependent on the Customer Number Reference Field? Needs a Dlookup or SQL to get the value(s) you need I think.

Hmm ... So unbelievably perhaps you think that children at primary school should not be reprimanded for making racist statements? Would you prefer that the child should not be admonished at all? If not then what should be done? How would you expect the school deal with it? The statistics you...

@The_Doc_Man Just as you “call ‘em as you see ‘em” I also feel the same about calling out any form of bullying, belittling or unjustified prejudice. The statement I reacted to was that “Racism is whatever a racist says it is because it is only an actual racist who sees race everywhere.” A few...

If that is a working definition of racism then I understand why it is considered that racists often have no conception / are blind to what racism is. Very pleased there is no chance of running for President.

However - The file number, in some instances, includes actual text? in which part? If it is in the second part, and you are unwilling to change / convert to just numeric values then you will not be able to sort it as you wish, unless perhaps there are specific rules for what text is used.

To use the DISTINCT keyword on multiple columns simply list the column names separated by commas after the DISTINCT keyword. cf your use of AND