Essay BIAM 530 Week 3 Discussions DeVry
BIAM 530 Week 3 Discussions DeVry
DQ 1 WORKING WITH DATABASE OBJECTS & MANIPULATING DATA IN THE DATABASE
- Review the Tiny College case concerning the Free Access to Current Technology or FACT library, at the end of Chapter 7 in the textbook (pp. 340–358) from the perspective of a database administrator assigned to build this database. Select one of the entities shown in the ERD for Tiny College’s database in Figure P7.56 on page 341. What data types would you use for the attributes in this entity? How would you code a CREATE TABLE statement to implement this entity as a table in the database?
- Continue examining the Tiny College case at the end of Chapter 7 in the textbook (pp. 340-358), but this time from the perspective of a manager in the organization. What is one example of a report from the database that a manager might want to receive? What data items would appear on the report, and what attributes and entities would these data items come from? How would you code a SQL SELECT query to retrieve this information?
DQ 2 WORKOUT ROOM
Please share your expertise on this Week’s Lab Assignment. Give examples or discuss topics you might consider using and help a classmate. Please post two (2) times throughout the week. (On two different days.)
Guaranteed A+Stop Stressing. Your Academic Success is Guaranteed.
Domyassignment is your direct route to higher grades. Thousands of students trust our PhD-level experts to deliver 100% original, custom-written papers—from tough essays to massive dissertations.
Zero Plagiarism (Free Report)
On-Time Delivery
Free Unlimited Revisions
100% Confidential
Secure Your Paper Now
