HELLO ALL, PLEASE I NEED SOLUTION TO THIS STUFF. Tnx.
1. Design a possible schema of doctor's office. The doctor wants immediate access to patient's medical information. The clerk needs to be sure all insurance companies are billed and each patient is billed for reminder.
2. Consider an inventory database at a kitchen cabinet factory which contains parts information (part number, description, colour, size, number in stock, etc) and vendor information (name, address, purchase order, etc). Indicate for each user, an account payable clerk, which item that user should be able to access and change.
3. Which type of user would usually perform the following functions for an inventory system in a large company:
a. Create a monthly report of current inventory value.
b. Update the number in stock for specific items received in shipment.
c. Cancel the user account for an employee who just retired.
d. Change the structure of the inventory database to include more information on each item.
e. Reply to a phone request regarding the number of a particular item that are currently in stock.
4. Consider a database at a university which contains information about students (name, ID number, course schedule, salary, etc) . Indicate for each user which item should the user be able to access and which item should the user be able to access and change
a. Faculty member
b. Clerk in registrar office
c. Student
d. Payroll check
1. Design a possible schema of doctor's office. The doctor wants immediate access to patient's medical information. The clerk needs to be sure all insurance companies are billed and each patient is billed for reminder.
2. Consider an inventory database at a kitchen cabinet factory which contains parts information (part number, description, colour, size, number in stock, etc) and vendor information (name, address, purchase order, etc). Indicate for each user, an account payable clerk, which item that user should be able to access and change.
3. Which type of user would usually perform the following functions for an inventory system in a large company:
a. Create a monthly report of current inventory value.
b. Update the number in stock for specific items received in shipment.
c. Cancel the user account for an employee who just retired.
d. Change the structure of the inventory database to include more information on each item.
e. Reply to a phone request regarding the number of a particular item that are currently in stock.
4. Consider a database at a university which contains information about students (name, ID number, course schedule, salary, etc) . Indicate for each user which item should the user be able to access and which item should the user be able to access and change
a. Faculty member
b. Clerk in registrar office
c. Student
d. Payroll check
