create all the necessary tables for this database, and choose a reasonable datatype for each attribute.

Homework assignment website: The Somerton High School PTO is creating a website that will allow students to quickly look up their homework assignments. The database supporting this website will keep track of departments, teachers, classes, and assignments. Each department has a name such as “math,” “science,” or “English,” and each teacher is a member of a single department. For each teacher, the database should store a title (“Mr.”, “Ms.”, “Dr.”, etc.), first name, middle initial, last name, office phone number, and e‐mail address. Each class is taught by one teacher; for each class, the database should store a name, description, meeting period (for example, seventh period), and room number. Finally each class has multiple assignments. For each assignment, the database should store the date assigned, the date due, and a text description of the work assigned. Obviously, the database also needs to remember which class each assignment is for, and which teacher teaches each class.

1.       Design a database to hold all this information. You may create synthetic keys as necessary or convenient. Create a database design outline and an ER diagram.

2.       In Access, create all the necessary tables for this database, and choose a reasonable datatype for each attribute. Assume phone numbers are in standard US format. If you use any “AutoNumber” synthetic primary keys, note that a matching foreign key should have a datatype of “Number,” with a field length of “Long integer.” Create all necessary relationships between the tables and enforce referential integrity. You do not have to enter any data or create any forms. Create a “Documenter” report for the database.

find the cost of your paper

Complete independent research and review two (2) to three (3) online end-user license agreements.

Complete independent research and review two (2) to three (3) online end-user license agreements. Compare and contrast each EULA with each other. In your response, please consider the following: ·….

Write a SQL query that identifies the number of prescriptions grouped by drug name.

ALY6030 Final Project Assignment – Pharmacy Claims Due End of Week 6 Background: The excel file “ALY 6030 Final Project Data Set.xlsx” contains sample pharmacy claims for made-up members of….

Create a JavaFX program to allow a user to query the Northwind database.

Create a JavaFX program to allow a user to query the Northwind database. You should be able to perform the following functionality using the program:   Print order total (not….