Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.
I can do all these but in one question I will do only one part. By when do you want this to be done ?
I mean, Question price is less and amount of effort and time is required to get this done is much more. So can you open 4 questions to do all these 4 parts ?
I am opting out for others.
Welcome to JustAnswer and thank you for utilising our services.
I will do it but depending on the amount of time that I will spend on it as my colleague mentioned earlier on, I might offer a premium service on submission of the answer.
Ok I have submitted an offer.
Ok when I made the offer I was considering all four parts
If it is fine you may accept the offer so I can start the deadline is too close. Thanks.
Ok. No I will not need to connect to your machine I will work on my side and then send you the answers when done. I will only ask questions in the process if need be.
Yes I am on it
Its very slow my tools are letting me down. I need to leave it to other experts to avoid wasting any more of your time.
Hi. I would be delighted to assist you with your RDBMS homework.
Unlike George, I will not play games with my fees. I am a recognized authority in the field. I was chief architect of the first multi-level secure (MLS) RDBMS to be embraced by the U. S. National Security Agency. I was also the author of the multi-level security extensions proposal to ANSI Level II SQL.
Not only that, but I have seen this Foods4U example before.
Do me a small favor: capture the COMPLETE assignment in ONE piece and post it in the Messages stream. Do NOT post bits and pieces which are expanded upon severally by subsequent bits and pieces.
When is your due date?
Just checking: have there been any prior assignments dealing with: Olympic sporting events and their venues; a private art gallery; or a student projects/advisors database? ;-)
Does any of this (see attached partial screen capture) look like it might be of relevance to the FineFoods4U database project?
"The real deal" here: not empty promises.
You can tell from a fraction of a diagram that the ERD is "wrong"?
Guess what: there are MULTIPLE solutions. Some people (such as those of us who have 30+ years' experience in database internals, personally having built the world's first multi-level secure relational DBMS [Trusted RUBIX] and contributed significantly to the National Computer Security Center's Trusted Database Interpretation of the Trusted Computer System Evaluation Criteria) see simplifications that, frankly, are beyond your professor, who is probably too focused on his/her way-beyond-reproach narcissistic/nihilistic microcosm to see anything that he/she didn't personally come up with.
Also bear in mind that what is considered an ERD varies. Some folks include relationship ovals; others include only hard schemata. Some insist on endless overspecification of crows' feet on lineal links; others don't. Why don't you post your professor's idea of an ERD so we don't end up counting beans. Thanks.
"No, that's wrong. THIS is the answer." No offense, but that's what I expect to hear from a "B" student. You have to think out of the box. I was a professor once upon a time, and many are stuck in their boxes, quite deeply nestled!
That "partial answer" looks like it's part of a solution involving 10+ tables. I was able to do everything with 6 tables.
Of course, some of the difference may lie in the reporting requirements. When the ability to generate a report that entails such-and-such is specified, some interpret that as, there must be a table that directly relates that information. That's actually the bonehead's approach if such data can be generated on the fly from a join of whichever tables, keeping the underlying schemata as simple as possible. I prefer the minimalist approach, also known as the CORRECT approach. It seems your prof is rather more of a plodder.