Your program must be done in Java; Your program must contain programmer comments explaining all aspects of the code; You must use proper programming style/format (indenting, spacing, proper variable names, etc.); The program must contain at least one searching algorithm; The program must contain at least one sorting algorithm; The program must use at least one array; The program must use built-in methods as well as methods (function and procedure type) created by you; Your program must access (read and write) a sequential file; The program must be efficient (don't write ten lines of code that can be written in two);

I have a HW that is asking me to draw on ERD diagram for a simple purchasing system that has order with order id, customer id, and date; order consists of one or more items; items consist of item id, description and price, and customers list customer id, name, and address. Can you help?

Suppose we have a database for an university. The requirements are as follows: • Professors have an SSN, a name, an age, a rank, and a research specialty. • Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. • Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). • Each project is managed by one professor (known as the project’s principal investigator). • Each project is worked on by one or more professors (known as the project’s co-investigators). • Professors can manage and/or work on multiple projects. • Each project is worked on by one or more graduate students (known as the project’s research assistants). • When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one.   The FDs for the above requirements are given as, • PSSN →…

With respect to union compatibility, in what situation does that make sense?