What do you think of the materials used in Smartphones?

You must write one paragraph, with a topic sentence and supporting ideas, and citations and an APA reference list.

Short-run cost function tables presented in chapter five include information detailing average variable cost, average fixed cost, average total cost, and marginal cost. Which of the figures do you consider most important for an organization to evaluate when determining levels of production? Why do you believe that factor is the most important?

no less than 250 words in length, make at least one reference to your text or other course materials and provide in-text citations. As you reference information from a source, be sure to provide APA citations in text and at the end of your post.

You are asked to design a relational database for a simple course registration software application for your school. The relational database must have the following information about the student, the course, and the registration, respectively

1. StudentID, FirstName, LastName, DataOfJoining, and Major
2. CourseNumber, CourseName,InstructorName, StartDate, EndDate, NumberOfCredits
3. ReferenceID, StudentID,CourseID, DateOfRegistration

Apply the following constrains while designing the database

1. Each student in the database must be uniquely identifiable
2. Each course listed in the database must be have unique CourseNumber
3. Each course registration must have unique ReferenceID.

A student can take multiple courses, but each course must be registered separately, and the following two rules must be applied

1. A student can do multiple course registrations
2. There can be many courses and a course can appear multiple times in the registration process.

Using pen and paper draw an Entity Relations Diagram (ERD) for the above application, then take a picture of it and submit. You may follow the below Steps for completing this assignment

Step 1: Identify the entities and their attributes involved in the given business.

Step 2: Write the entity names and their attributes along with the data type as tables.

Step 3: Identify the primary key fields and mark them as PK.

Step 4: Read and understand the business rules. Then, create natural relations between

entities that can capture the business rules. Identify the foreign key fields and mark them as FK.

Create an application to simulate a bank ATM and you must combine graphical interfaces using Swing or AWT and relational databases.

We will have a Bank Accounts database. Each account will have an account number, the name of the owner and the account balance.

The program must allow the following options:

a) Create an account: request the account information and save it in the database.

b) Enter the ATM: it will allow you to request the account number and will go to the next part of the program.

c) Close an account: delete it from the database

d) Exit

The second part of the program will perform the typical tasks of an ATM. It must perform the following:

a) See the account balance: Display the balance of the account. (The account has already been previously registered)

b) Deposit a money in the account: request the value to deposit and increase the balance in that value.

c) Withdraw money: request the value to be withdrawn, and if there is sufficient balance, this balance decreases in the value to be withdrawn.

d) Transfer money to another account: request the number of the other account and the value to be transferred, and if the other account exists and the balance is sufficient, decrease the source account by the indicated value and increase the balance of the other account by The transferred value.

e) Exit.

The program must be written in Java and you can use a desktop database (Access or H2 or Derby or Sqlite or HSQLDB) or a client-server database (MariaDB, MySQL or PostgreSQL).

Explain what is meant by cardinalities in database.

Why is atomicity in database design important?

I think that SQL language is a great tool for database creation and manipulation. The basics of SQL are easy to learn and understand. The coding is simple from the creation, changing, or even deleting data from the database. I overall really like learning SQL I can easily visualize what I am doing with the code.

What could be added to this post?

Assume that you have a Saudi league player database. In this database, you have a table containing players’ attributes such as (Name, age, position, etc.) and you decided to add information about players’ agents. Would you represent the agent information as attributes in the player table or would you create an entity set for players’ agents? Justify your answer.

For the given database schema. Answer the following questions.

Company Database customer(cust_id, name, address)

product(product_id, product_name, price, quantity)

transaction(trans_id, cust_id, time_date)

product_trans(product_id, trans_id)

Identify the primary keys and foreign keys for the relations and specify at least two different types of integrity constraints that would be applicable for different relations given.