SQL ER Diagram

Build a data model relationship diagram/ER diagram (with visio and/or lucid charts) . The data model should be extremely clear for cardinality, as many attributes as possible with primary key and foreign key relationships. Summary: I am a startup company called whatever you want to call it that has three investors(tech/science companies) from three different foreign countires like Iran, Canada, and France(does not matter) each has to be affiliated or the company is made up from a primary, secondary, and tertiary, sectors. For example, there is Biotechnology as a primary, secondary can be synthetic biology and teritary can be neurotech with subsectors. From these three companies, its up to you to declare which companies has how much equity percentage and the goal is to introduce this diagram to another company in order to convince them to get more funds but the company has to own at least 35% of its buisness or else it has affiliation risk or funding concentration risk. It can be any three different companies. And it does not have to be a real world company. Create multiple records of the application and related entities and then insert them with some different values of Affiliation, funding sources. There also has to be a record of how much the company is worth and possibly the other countries net worth so the start up company can present that to the company they want funding from. Hope this is specifc enough. Here is the photo of a sample application that has further details on what is needed. Below is a same application. Hope the application gives an idea on what to do. COMPANY APPLICATION SECTION Company Applicant: M-Field 1) First Name: Field 2) Middle Name: M-Field 3) Last Name: M-Field 4) Phone Number: M-Field 5) Email: Please provide the following information on the company Company Information 1. Company Name: M-Field 1) Dun and Bradstreet Company Name: M-Field 2) EINDuns Number: Field 3) Doing Business As (DBA): Insert a stacked check box and one “type in” field below (Same as above) (N/A) (Type in Name) 2. Entity Type: M-This should be a drop down menu (C-CORP, S-CORP, B-CORP, Limited Liability Partnership, Limited Liability Company) 3. Business Entity Corporate Headquarters Address: Same as CP comment about “Corporate” M-Field 1) Street Address (Type in) M-Field 2) Unit Number or N/A (Type in) M-Field 3) State (Drop Down two letter States) M-Field 4) Zip code (Type in) 4. Other Business Address(es): Other Offices In the U.S. Field 1) Street Address (Type in) Field 2) Unit Number or N/A (Type in) Field 3) State (Drop Down two letter States) Field 4) Zip code (Type in) 5. U.S. State of Same as AboveIncorporation: Same as CP comment about “Incorporation” M-(Drop Down Menu) Two letter State Code 6. Finish and Continue: Button Applicant is required to fill in all mandatory fields (those annotated with M-) prior to moving on) Any fields not filled in must be annotated to the applicant so they can go back and fill them in. NEW LANDING PAGE Company Application Section A: Company Description 1. Please provide a brief description of the company: Open Field: paragraph entry 2. Please indicate the primary, secondary, and tertiary Government technology sector and sub-sectors your company is engaged in: Drop Down Menus: Users will select a primary, secondary, and tertiary sector from drop down. Then they will select as many(1 to N) sub-sectors under the primary, secondary, and tertiary fields as annotated below. M-Field 1) Primary Sector: drop down PRIMARY, SECONDARY, & TERTIARY SECTORS: Field 2) Secondary Sector: drop down PRIMARY, SECONDARY, & TERTIARY SECTORS: Field 3) Tertiary Sector: drop down PRIMARY, SECONDARY, & TERTIARY SECTORS: USERS WILL BE ABLE TO CHOOSE AS MANY SUB SUB-SECTORS AS THEY WISH M-Field 1) Primary Sub-Sectors: drop down PRIMARY, SECONDARY, & TERTIARY SUB- SECTORS: Field 1) Secondary Sub-Sectors: drop down PRIMARY, SECONDARY, & TERTIARY SUB-SECTORS: Field 1) Tertiary Sub-Sectors: drop down PRIMARY, SECONDARY, & TERTIARY SUB-SECTORS: PRIMARY, SECONDARY, & TERTIARY SECTORS: Biotechnology, Artificial intelligence (AI) and machine learning technology Position, Navigation, and Timing (PNT) technology. Microprocessor technology Advanced computing technology Data analytics technology Quantum information and sensing technology Logistics technology Additive manufacturing (e.g., 3D printing) Robotics Brain-computer interfaces Hypersonics Advanced Materials Advanced surveillance technologies PRIMARY, SECONDARY, & TERTIARY SECTORS WITH SUBSECTORS: Biotechnology, (i) Nanobiology; (ii) Synthetic biology; (iv) Genomic and genetic engineering; or (v) Neurotech. Artificial intelligence (AI) and machine learning technology (i) Neural networks and deep learning (e.g., brain modelling, time series prediction, classification); (ii) Evolution and genetic computation (e.g., genetic algorithms, genetic programming); (iii) Reinforcement learning; Position, Navigation, and Timing (PNT) technology. Microprocessor technology (i) Systems-on-Chip (SoC); or (ii) Stacked Memory on Chip. Advanced computing technology (i) Memory-centric logic. Data analytics technology (i) Visualization; (ii) Automated analysis algorithms (iii) Context-aware computing. Quantum information and sensing technology (i) Quantum computing; (ii) Quantum encryption; or (iii) Quantum sensing. Logistics technology (i) Mobile electric power; (ii) Modeling and simulation; (iii) Total asset visibility; or (iv) Distribution-based Logistics Systems (DBLS). Additive manufacturing (e.g., 3D printing) Robotics (i) Micro-drone and micro-robotic systems; (ii) Swarming technology; (iii) Self-assembling robots; (iv) Molecular robotics; (v) Robot compliers; or (vi) Smart Dust. Brain-computer interfaces (i) Neural-controlled interfaces; (ii) Mind-machine interfaces; (iii) Direct neural interfaces; or (iv) Brain-machine interfaces. Hypersonics (i) Flight control algorithms; (ii) Propulsion technologies; (iii) Thermal protection systems; or (iv) Specialized materials (for structures, sensors, etc.). Advanced Materials (i) Adaptive camouflage; (ii) Functional textiles (e.g., advanced fiber and fabric technology); or (iii) Biomaterials. Advanced surveillance technologies (i) Faceprint and voiceprint technologies. 3. Please indicate all of the North American Industry Classification System (NAICS) Codes for your company: Unlimited number of codes can be added here 4. Please list any company patents on critical defense technology by name and number: Unlimited number of patents can be listed here Field 1) Patent Name Field 2) Patent Number Field 3) Country of Patent

Get Help With a similar task to - SQL ER Diagram

Login to view and/or buy answers.. or post an answer

Related Questions

Similar orders to SQL ER Diagram
57
Views
0
Answers
MySQL Homework: Employee Tracker

Developers are often tasked with creating interfaces that make it easy for non-developers to view and interact with information stored in databases. Often these interfaces are known as **C**ontent **M**anagement **S**ystems. In this homework assignment,...

57
Views
0
Answers
LAB 1 Assignment SQL

Now that we have a relatively good understanding about creating tables. We will need to go a step farther and start using them. This assignment will consist of a few requirements –


- You will be creating a Registration table and a...

78
Views
0
Answers
EMPLOYEE MANAGEMENT SYSTEM with the use of Tkinter, OOP concept, using database(SQL) to store data

A.GUI based application. b. Implementation of Object-oriented concept c. Data of your application should be persist in database. d. Unit Testing of your application e. Simple algorithm for searching and sorting

...
89
Views
0
Answers
help with taking my database exam online

MIS 4300 Fundamental Database exam. The exam will be over Chapter 10 (Transaction Management and Concurrency Control) and Chapter 11 (Database Performace Tuning and Query Optimization). 25 MCQs- 25 minutes dura...