Typically, a hospital patient receives medication that have been ordered by a particular doctor. Because the patient often receives several medication per day, there is a 1:M relationship between PATIENT and ORDER. Similarly, each order can include several medications , creating a 1:M relationship between ORDER and MEDICATION.a. Identify the business rules for PATIENT, ORDER and MEDICATIONb. Create a Crow's Foot ERD that depicts a relational database model to capture these business rules.

Consider the following relations in the relational schema for a database that keeps track of business trips of Sales Representatives in a sales office:    salesperson(SSN, lName, startYear, deptNo) trip(tripID, SSN, fromCity, toCity, departureDate, returnDate) expense(tripID, accountNumber, amount)   Part 1 Answer the Following 3 Questions.  Places Your Answers in a Word Processor     identify the primary key for each table. Identify the foreign keys in each table. Given the above foreign keys, list the order in which the tables could be successfully created. Write your Answers using a Word Processor     Review the Relational Schema and other necessary material in this assignment to create the metadata document for the above relational schema.      Write your Metadata using a Spreadsheet or a Word Processor.  Submit the Final Version as a PDF     Open up a text editor such as Visual Studio Code.  Write the SQL SELECT Queries to respond to the following Information Requests     Find…

Imagine you have been tasked with cataloging the information found in books. Either more books need to be added, or the ones on one side of the shelf need to be rotated out. Find the optimal data structure and explain why it works here. Add books to the shelf in a dynamic fashion. When new information must be added to an existing database but there isn't enough space, what happens?

Give a relational database schema for the following: EMPLOYEE (Fname, Minit, Lname, SSN, Bdate, Address, Sex, Salary, Super_ssn, Dno) PK= Ssn FK= Super_ssn DEPARTMENT ( Dnamc, Dnumbcr, Mgr_ssn, Mgr_start_datc) PK= Dnumbcr FK= Dno DEPT_LOCATIONS (Dnumber, Dlocation) PK= Dnumber FK= Dnumbcr PROJECT (Pname, Pnumber, Plocation, Dnum) PK= Pnumber FK=  Pno WORKS_ON (Essn, Pno, Hours) PK= Pno FK= ssn DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship) PK= Essn FK= Ssn