First, draw an EER that models the given requirements.
Homework Answers
Add Answer to:
First, draw an EER that models the given
requirements.
You will play with the Bank Database...
DATABASE Draw an ER diagram according to the following requirements. The bank application keeps track of...
DATABASE Draw an ER diagram according to the following requirements. The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount....
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Draw an ER diagram according to the following requirements. The bank application keeps track of the...
Draw an ER diagram according to the following requirements. The bank application keeps track of the following information. As a customer of the bank, he/she must either own an account or borrow a loan. The banking application does not require a customer to both own account and borrow a loan. Customer information includes a SSN (unique), a name, and an address. A customer can borrow at most one loan. A loan has a loan number (unique) and an amount. A...
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database...
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where...
Develop an EER (ER) model for the following situation using traditional EER notation. You have been hired...
Develop an EER (ER) model for the following situation using traditional EER notation. You have been hired by a new start-up company, IT Consulting – a company that consults with corporations to determine their security needs. You came up with the following set of entities, attributes and business rules: CONSULTANT 2 types of consultants – business consultants and technical consultants. Business consultants first work with a company for security needs, technical consultants perform services according to specs developed by business consultants. Attributes...
Problem 1 Consider the following set of requirements for a university database that is used to...
Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Project Description In this project, you will design and implement a database for keeping track of...
Project Description In this project, you will design and implement a database for keeping track of information for an online “SOCIAL NETWORK” system (e.g. a simplified version of Facebook!). You will first design an EER schema diagram for this database application. Then, you will map the EER schema into a relational database schema and implement it on ORACLE or MySQL or some other relational DBMS. Finally, you will load some data into your database (via user Interface) and create some...
Sample data is provided for the database for the sales system. Using the sample data, you...
Sample data is provided for the database for the sales system. Using the sample data, you will determine the entities, key components of the entities, and business rules for the entities. Using the entities and business rules you will then create an ERD. Tasks: 1. For each entity provide the name, description, fields, data type, primary key, and foreign key. 2. For each direct entity type pair, provide the business rules. 3. Provide the ERD. Customer Table Customer ID, Last...
Design a database for FreeChecking Bank, including information about customers and their accounts. Information about a...
Design a database for FreeChecking Bank, including information about customers and their accounts. Information about a customer includes name, address, phone, and social security number. For each account, we know the account number, type (e.g., savings, checking) and balance. Also the information about which customer owns which account is stored.
You are in the final stages of designing a database. You notice that in your requirements...
You are in the final stages of designing a database. You notice that in your requirements gathering documentation, when customers call on the phone to ask a question, the customer service representation asks for their phone number first as opposed to their last name. In order to speed this retrieval up, which type of index would you place on the phone number field? a. Sequential b. Unique c. Non-Clustered d. Clustered
Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, birth date, sex, class (freshman, sophomore,., graduate), major department, minor department (if any), and degree program (B.A., B.S.,..., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where...
Problem 1 Consider the following set of requirements for a university database that is used to keep track of students' transcripts. (a) The university keeps track of each student's name, student number, social security number, current address and phone, permanent address and phone, birthdate, sex, class (freshman, sophomore, -, graduate), major department, minor department (if any), and degree program (B.A., B.S., ...., Ph.D.). Some user applications need to refer to the city, state, and zip of the student's permanent address,...
Most questions answered within 3 hours.
-
Draw a combinational logic circuit diagram with a symbol inside
the box for two I/P of...
asked 12 seconds from now -
The cliché we use quite a lot in finance is: there is a need to
maximize...
asked 5 minutes ago -
In class we discussed the addition of HCl to alpha pinene. Would
you expect one or...
asked 5 minutes ago -
I'm trying to explain to my daughter to help her please help
me
I tagged the...
asked 12 minutes ago -
You want to accumulate $28,000 in 10 years using annual
payments, the first one in a...
asked 20 minutes ago -
1. Name the 4 products obtained from the reactions of the light phase of photosynthesis.
2....
asked 21 minutes ago -
An electron in an excited hydrogen atom makes two transitions.
First the electron drops from the...
asked 31 minutes ago -
1) I have 50.0 g of ethanol (C2H5OH) at 100 K. I want
gaseous ethanol at 373...
asked 37 minutes ago -
Under which Article of the United States Constitution
can a federal court order a State employee...
asked 37 minutes ago -
You mix 5 moles of H2 at 300 K with 5 moles of He at 360...
asked 42 minutes ago -
In Python,
Write a complete program to input up to a maximum of 25
characters into...
asked 47 minutes ago -
A ship sailing in the sea enters a wide and deep
River. The density of seawater...
asked 50 minutes ago