1. Create an ERD that has at least 5 tables in it and include all of...

1. Create an ERD that has at least 5 tables in it and include all of the details and the correct notation (Min/Max cardinality and relationship name.)

2. Write a paragraph that explains the ERD.

3. Write the SQL Create, Insert, and Update statement to insert one of the entities from this ERD into a database.

Expert Solution

venereology answered 1 year ago

Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all...

Create an ERD (using Crow’s Foot Notation) for the following description. Be sure to include all necessary entities, attributes, and correct cardinality in relationships between entities. You have been asked to build a database for a sportswear company called AthFleet. The company owner needs to keep track of the customers that buy their products, the employees that work at AthFleet, the vendors that provide them with products, and the products themselves. Each vendor has contact with one employee representative and...

Phase 1 – ERD In this phase of the project you will create an ERD based...

Phase 1 – ERD In this phase of the project you will create an ERD based upon the following requirements and business rules. Limit your ERD to entities and relationships based on the business rules showed here. In other words, do not add realismto your design by expanding or refining the business rules. However, make sure you include all attributes needed that would permit the model to be successfully implemented, including all primary and foreign keys. 1.Trinity College (TC) is divided...

Using PHP and MySQL Create a simple web form with at least 5 fields Include validation...

Using PHP and MySQL Create a simple web form with at least 5 fields Include validation and error messages Create a MySQL Database Create a table to store submissions from the form Only insert new data into the database when all validation is passed Use PHP to create an HTML table showing all the content of the database New submissions should appear in table

Develop the SQL scripts that will create the tables and enforce all the appropriate constraints •...

Develop the SQL scripts that will create the tables and enforce all the appropriate constraints • Develop sample SQL scripts that will insert the data to the database (one row in each table) • Convert at least 2 entities to MongoDB Collections. Write the scripts that will Create the collection(s)

Create tables according to the mapping. Add 2 records to each. Create 5 queries for database...

Create tables according to the mapping. Add 2 records to each. Create 5 queries for database of 3 table joins to use most of the tables or group of tables in database. You should not have tables that are of no use. Student(ssn, name, major) Class(classID, name, f_ssn) Faculty(ssn, name, office_num, dept_id) Department(Dept_id, office_num, f_ssn) Enroll(s_ssn, classID, grade) Professor(f_ssn, alma-mater, tenured) Instructor(f_ssn, term_degree, type) Lecture(classID, method) Lab(classID, location) Person(ssn, dob, gender)

Compare and contrast transformation, transduction and conjugation. Include at least 5 different comparisons/contrasts between all three.

Tables: Create table Item( &nbs... Bookmark Tables: Create table Item( ItemId &nb

Tables: Create table Item( &nbs... Bookmark Tables: Create table Item( ItemId char(5) constraint itmid_unique primary key, Decription varchar2(30), Unitcost number(7,2)); Create table Customer( custID char(5) constraint cid.unique primary key, custName varchar2(20), address varchar2(50)); Create table Orderdata( orderID char(5) constraint oid_uniq primary key, orderdate date, shipdate date, ItemId char(5) references Item.ItemId, No_of_items number(4), Unitcost number(7,2), Order_total number(7,2), custID char(5) references customer.custID); Insert Into Item values(‘A123’,’Pencil’,2.5);...

Write the SQL DDL to create the following 5 tables for an App store: Publisher, Category,...

Write the SQL DDL to create the following 5 tables for an App store: Publisher, Category, App, AppVersion, AppVersionReview: A Publisher table where each publisher is identified by an integer id and has a name (up to 40 characters). (1 mark) A Category table where each category has an id (integer), a name (up to 50 characters), and a parentId to identify its parent category. The parentId should be a foreign key to the Category table. (1.5 marks) An App...

Database: Question 11 Using the ERD from problem 10, create the relational schema.(Create an appropriate collection...

Database: Question 11 Using the ERD from problem 10, create the relational schema.(Create an appropriate collection of attributes for each of the entities. Make sure you use the appropriate naming conventions to name the attributes.)

You must create an ERD diagram for medical office wait times for patients with the following...

You must create an ERD diagram for medical office wait times for patients with the following minimum requirements. Your ERD diagram must include your Business Rules with a min. of 10 rules At least 5 entities. These may be real (e.g. a person, vehicle, etc.) or abstract concepts (e.g. course, enrollment, categories, etc.) • There must be logical relationships between the entities. • Aim for all entities to have a minimum of seven attributes, but no fewer than 3 entities...

Question